Question:
Hi
I have a Key Figure (0INVCD_VAL) and 0CALMONTH in my Query. I need to get a subtotal for every 3 months ( Jan+ Feb+ March = Sub Total 1 and Apr+May+June = Sub total2, July+Aug+Sep = Sub total3, and Oct +Nov+Dec = Subtotal4), and finally get a Grand Total for the particular year. Is there any better solution for that?
Thanks in advance
Answer:
If you use the infoobject 0CALQUARTER as a time characteristic on your cube it should do the trick.
Cheers,
Darren
Answer:
Hi Darren,
Thank you so much for your advice. Perfectly it works.
Thanks again.