Pivot chart with Dimensionality() is not working perfectly.

[nilapril2010]

Hi All,

We have hierarchical data in the following structure -

tbl :
LOAD * Inline
[BA,Country,Area,Brick,Value,Level
Eu,Den,X,1,10,1
Eu,Frn,Y,1,12,1
Eu,Ger,Z,1,30,1
Eu,Ger,Z,2,50,1
Eu,Ger,A,1,20,1

Eu,Den,X,X,10,2
Eu,Frn,Y,Y,12,2
Eu,Ger,Z,Z,80,2
Eu,Ger,A,A,20,2

Eu,Den,Den,Den,10,3
Eu,Frn,Frn,Frn,12,3
Eu,Ger,Ger,Ger,100,3

Eu,Eu,Eu,Eu,112,4];

Level 1 is Brickwise data.

Level 2 is Areawise summary.

Level 3 is Countrywise summary.

Level 4 is BA wise summary.

We have a pivot chart with the following expression -

if(Dimensionality()=0,Sum({<Level={4}>}Value),
if(Dimensionality()=1,Sum({<Level={3}>}Value),
if(Dimensionality()=2,Sum({<Level={2}>}Value),
if(Dimensionality()=3,Sum({<Level={1}>}Value)))))

The dimensiona are Country, Area and Brick.

The pivot is showing perfect result, when we drildown the pivot chart. But it is not affected when we change selection in other charts.

Can you explain the reason ?

[Gysbert_Wassenaar]

Please don't double post the same question: Issue in Pivot Table with Dimensionality in expression‌

And please explain what the problem is. I don't understand what you expect that should happen.

[amayuresh]

Firstly, it should get affected by other selection.

If you do not want the impact of other selection, use Alternate State to avoid the impact of other selection on this chart.

if this is not answer to your question, please post your question with example.

[Chanty4u]

chk dis once,

Chart Dimensionality

How to use - Dimensionality()