I am trying to create the below chart and I can't make it happen:
1.The user needs the Market & its Products in one column like above. the first red circle represents the Market and the second circle represents the Products that Market have. How do I show into Pivot table ?
2. How do I create the MTD & YTD values for Time dimension value ?
3. Market growth = CURRENT_MONTH/ LASTYEAR_CURRENT_MONTH. How do I calculate this expression if I have the time dimesion ?
Thanks in Advance....
you can find a good example in the same community.
Using a master calendar for "concatenate" function by entering "InWeek, InMonth, InYear etc ...
The objects are functioning.