Dimension after Expression

[#1]

hi all,

i'd like to ask, is it possible to add a dimension after an expression on pivot chart ?

|Dimension A|Dimension B|Dimension C|Expression A|Expression B| -> |Dimension A|Dimension B|Dimension C|Expression A|Expression B|Dimension D|

thank you

[v_iyyappan]

Hi,

     Dimension after expression possible in pivot table because its simply drag the ' dimension | expression '  in  pivot table.

I attached a sample QV

Iyyappan

[rajni_batra]

u used straight table in the example i dont think the same would b possible in pivot..

[#4]

is that straight table ? sorry i can't open the file you attached, i have personal edition here.. but thank you lyyappan

can you attach new file with pivot chart that shows a dimension after expression?

[#5 · Accepted solution]

Its not possible to have a dimension after an expression in a pivot table. This would break its ability to expand and collapse the pivot.

If you simply wish to display another field then you can do this using an expressions and the only() function which will display the value in the given field as long as only one distinct value is possible.