Hi Everyone,
I am using a Calculation View for reporting on Analysis Office.
In my View, I have created multiple Calculated Columns.
Like, say I have 3 measures in my table as Bonus, Salary and Tax
I created a Calculated Column Total as Bonus+Salary+Tax
Now my requirement is that in my report when I click on Total - I should be able to see all the fields it is composed of i.e. I should see Bonus, Salary and Tax on clicking Total( Total as 1st Level and others at second level)
Is there a way to achieve this?
Regards,
Vivek