hello Teri,
Point 1 is not a problem any more once I added year prompt. Thank you.
2) if you join original source with aggregated table, do you perform usually left join and put all the columns? I have never done it yet. It will be my first aggregation
I have page prompt going from broad category to the smallest category and one aggregated measure number of customers where I need to calculate average or moving average. As of nested aggregation, I am not able to do it. Then when performing aggregation do I need to all of the hierarchies of categories as these will be my page prompts I want to filer on? regards Karolina Touwen
... View more