Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one pie chart in which we are showing market share by product.
Dimension--> Product
Expression--> Market Share
My requirement is if any product is selected then the chart should change like, if there are 4 products and product A is selected then it should make 2 groups like product A and all the remaining products should be in other group as 'Others'.
Is it possible to make the groups depending on selection like,
Selected product and 'Others'.
Others should include all the other products.
Thanks in Advance..!
try with variable like below
vGroup=min(Product)
take dimension below
if(len(Product)>0,if(Product='$(vGroup)','$(vGroup)','Others')
Hi find attachment
Our issue is,
In your application file if we select A,B then chart should display three buckets in pie those are A,B,'Others' , in which others will contain C's and D's values (excluded values)
Thanks
Hi,
Sorry I have not provided the complete requirement.
Thanks for quick response. Your sample application is working fine if only single product is selected. But its not working if multiple product are selected.
Like if 2 products are selected A and B, then there should be 3 groups. A, B and Others.
Is there any way to do this.
Hi Priya,
Please find attached file for solution.
Regards,
Jagan.