Self service Report of Conditional showing dimensions issue in Pivot table view

[mahesh_m1029488]

Hi ,

I have created a Pivot table of self service report , where the user can select any number of dimensions from a list box and also metrics .

The chart will load dynamically.

Here the problem is the number of dimension & metrics are conditionally working upto 6 max.

But if there is no conditions we can see all the dim & metrics as all of you know

My client wanted to have all selection view . But when ever the dimension selection is crossing 6 max , the pivot chart automatically minimizing to one cell.

Please help if there is any option ?

[udaya_kumar · Accepted solution]

I think you are using GetFieldSelections() function to get the dimension values and show and hide the dimensions based on that.

If yes, then please use the below expression

Your expression (I think so)

GetFieldSelections(Dimension)

New expression (Use this one instead of above expression)

GetFieldSelections(Dimension,',',100)

Try this and let us know.

[Anonymous]

Uday Kumar solution should work. By default, GetFieldSelections() function holds upto 6 values. If you want the function to hold more values, you can specify the max number of values like 100 as mentioned.

[mahesh_m1029488]

Thank you soo much ..