Hi ,
I have a data with following column ,
- ItemName
- Quantity
- Invoice Date
- Distributor Name
I'm creating chart with "ItemName" in the dimensions and I Think , I think I'm able to bring top 10 "ItemNames" by using the following syntax in the expressions "Sum({<ItemName= {"=Rank(Sum(Quantity)) < 11"}>} Quantity)".
My challenge here is I'm trying to filter this chart by the Distributor Name" .
I have 4 distributors DIST A, DIST B , DIST C and DIST D , so I'm trying to create 4 charts and each dedicated to one particular distributor and their top 10 ItemName.
Can someone please help me .
Thanks in advance.