Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear,
I have two table with this fields
ItemID | ItemTitle
1 | IT1
2 | IT2
3 | IT3
4 | IT4
5 | IT5
.....
CustomerName | Item Title | Quantity
C1 | IT1 | 5
C2 | IT2 | 4
C1 | IT1 | 6
C1 | IT2 | 7
C3 | IT1 | 3
C2 | IT2 | 2
............
.........
..........
when i select a customer i want display bellow values:
ItemTitle | TotalQuantity for all Customer | Total Quantity of Top(10) of customer buy more | Total Quantity of selected customer
Hi,
You are not stating an issue, you are asking us how to do a standard visualization? How far did you get with your data model and visualizations before coming to the forum?
My problem is that i can't calculate top(10) Quantity of best buying customers.
You can restrict in Dimensions limit to show top 10 best buying customers.
Just try the below 3 expression
TotalQuantity for all Customer = Sum (total<customer> Amount)
Total Quantity of Top(10) of customer buy more = Sum ({<customer={"=Rank(sum(amount)<=10)"}>} Amount)
Total Quantity of selected customer = Sum ( Amount)