How to add dummy dimension in Pivot level chart

[sarfaraz_sheikh]

Dear All,

Can anybody tell me how to add dummy dimension in pivot level chart

Sarfaraz

[sunny_talwar]

Not sure what you mean by Dummy Dimension, but if you mean to add a dimension which isn't available from the database, you can try ValueList() or ValueLoop() functions.

[antoniotiman]

Hi,

I agree with Sunny.

If You use ValueList('a','b') as dimension, You need Expression Like

If(ValueList('a','b')='a',Sum(TOTAL <DIM> Value)) and so on.

See sample attachment.

Regards

[Kushal_Chawda]

use Valuelist function

Go to chart properties -> Dimension tab

Add calculated dimension

=Valuelist ('Dummy1','Dummy2',..)

or if you want just single value as Dummy dimension, then add calculated dimension as below

='Dummyvalue'