Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we create individual Pie Chart with each combination of Dimension and Measures selected from a list box?
maybe alternate states would it mke it easier. I didnot work with them yet
for your 3 pie Charts with 3 independant Dimension and measure you Need 3 inline table with 3 different fieldnames
Dim1:
load * Inline [
Dim1
Region
Product
];
Dim2:
load * inline [
Dim2
Region
Product
];
etc.
this should work. It might get better Solutions.
Yes...and tats where I am stuck....the getfieldselection is not working for multiple selection in the listbox
Hi John,
See attached, based on the ad hoc, just done for the company Dimension
Andy
Hi Andy,
That was really helpful,to make it more user friendly....can we use a conditional view for each chart?
Is there any function so that if the selection is made on just Company and Sum it will display only the respective chart and on next selection of Avg it pops up the second chart?
Yes, you could do all that with conditional views! Happy playing