How to create a calculated dummy dimension

[Anonymous]

I,

In the small example attached I want to create 1 line with the difference between dimension dim1 when 'A' and dimension dim1 when 'B'.

What is the best way?

[Siva_Sankar]

Hi Ricardo,

Not understanding your requirement clearly. Can you post your expected output and little more description?

Siva

[Anil_Babu_Samineni]

Like this?

[Anonymous]

I could not explain myself well (maybe in the late hour).

What I intend is: having a table of facts with several snapshots, when selecting 2 can compare 1 with another.

In the new example I send, I have 1 Char "With Variable" in which I wanted a new column that would be "A-B".

I almost got it with the ValueList (char "With ValueList"), but when I enter a DrillDown dimension with a "pivot" type char it stops working.

Summarizing what I intend is what I have in the "With ValueList" chart but where I can have a drill dimension and maintaining a Pivot Table.

please see the new attachment

[Anonymous · Accepted solution]

Hi Ricardo

See the attached sample please.

In table With Value List

I removed your dimension div and dep and replaced it by your drill down dimension hierar

Then in chart properties, tab presentation, checked Always full expanded.

.

Then to get A, B and A-b in column drag one of them to the top of your chart. And then tou get your crossed table.

This worked for me.

Give it a try.

Regards,

Sílvia

[Anonymous]

Work ! nice and smooth .

thanks a lot

Ricardo