Skip to Content
1
May 06, 2014 at 09:42 AM

Question on Calculation View

24 Views

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