Question on Calculation View

[vivekbhoj]

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

[raghavendra_n]

Hi Vivek,

You can use "display measure folder". You can arrange Total & all its components into folder structure as shown below. The option is available in the semantic node toolbar.

Regards,

Raghu

[former_member184871]

Hi Vivek,

Hopefully hierarchies will solve your issue.

Refer:

you can also refer : http://www.saphana.com/docs/DOC-2375

Regards

Kumar

[vivekbhoj]

Hi Mayuresh,

I am already using Hierarchy for Attributes.

In Hierarchies, you can use Attributes only as you don't get the option to include measures in hierarchies.

Another thing is - there is no relation between the values that are used in creating calculated columns

Regards,

Vivek

[former_member184871]

Hi Vivek,

Thanks for correcting me, I missed that.

Can you try creating the Hierarchy using office analysis, If possible as - (I don't have clue if that is possible or not)

Regards

Kumar