Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart which has Top Selling product, now I want to create Bottom selling product in the same chart using cyclic or drill down group.
Can anyone help me wid this.
You can create a new Cyclic Group for TOP 10 and Bottom 10 Customers like below..
For TOP 10 :
IF(Aggr(Rank(SUM(Sales)),Customer)<=10, Customer)
For BOTTOM 10 :
IF(Aggr(Rank(-SUM(Sales)),Customer)<=10, Customer)
Now create a straight table
Use this CycliGroup as Dimension
Tick Supress When Value is Null
Expression:
SUM(Sales)
NOTE : Replace Customer with Brand/Product/Country as per your requirement for above Calculated Dimensions..
Hope this help...
Try some thing like.going expressions write two expressions for top and bottom and then.going expression make group.
1)Create expression for top 2)expression for bottom then --->click on second expression then
----->find the group property---cyclic will come.
hope helps you
regards
Mahesh T
try this thing in backend then u can use this in Dimensions
Hi Renuka
Use Button object to Show Top/Bottom Selling Product instead of showing it with Cyclic/Drill-down Approach.
It's very useful.
Refer the Attached Samples.
Regards
Aviral