calculated dimension problem

[viveksairam89]

hi ,

I have requirement I need to display a pie chart based on my selection category and others should group by and should show others in pie chart

For example

LOAD * INLINE [
category, sales
audio, 400
video, 300
a, 200
b, 100
];

if iam choosing audio and video in list box it should reflect in pie chart like audio ,video and

a,b should be others in pie chart it should groupby the sales and should show others in pie chart

like dynamically need to dimension

Regards

vivek

[sunny_talwar]

Check out the attached:

[MarcoWedel · Accepted solution]

Hi,

another solution could be using a dimension limit like:

=RangeMin(GetPossibleCount(category)+1,FieldValueCount('category'))

hope this helps

regards

Marco

[viveksairam89]

Hi,

Thanks Marco and thanks sunny