Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
arunqlik2view
Creator
Creator

Need to create charts with same dimension against Top 10 of Total Quantity , also filter each chart with just one Distributor

Hi ,

I have a data with following column ,

  1. ItemName
  2. Quantity
  3. Invoice Date
  4. 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.

0 Replies