Hi
Here is my Requirement I have to display Grand Total row but with this requirement
Sales, Goals and LY Sales are fine. But for % to LY and % to Goal it is displaying total of of rows but I want
to display %to Goal total should be Grandtotal of Sales / Grand Total of Monthly Goals
same for %to Ly = Grand total of Sales / Grand total of LY
Is it possible ?
Thanks
Naman
3 Antworten
If I have something like this then your equation is not working
Equation i wrote for % to MTD
SUM({FIXED [U_Division]:SUM([MTD])})/SUM({FIXED [U_Division]:SUM([Monthly Goal])})
Please guide me
