We have looker adhoc reporting based on a view which is at item-location-day level. So all the facts(sales, inventory) that could be at item-location-day level, the measures could be created.
Example: an item I was sold at location L on Day - 18th July, 2019. Thus the Sales fact could be $X for that ILD. We can have a table/view at warehouse with these columns.
Question: I have a fact whose lowest level day data is Month and let’s say that of Product is “category”. Please note that the facts like “Planning amount” could not be divided at item-location-day level but at category-month level only.
How am I able to see the reports separately, as mentioned -“problem” in the screenshot below?