undefined

[Korekar27]

PFA two datasets for your reference.

PFB Scenario Objectives:

1) Load the Superstore data to calculate no. of orders that have been generated for the last 6 , 12 , 18 months based on a filter selection.

2) Load the BusinessE2E data to perform the below activities:

• Create an optimized data model
• Create dynamic YTD , MTD , QTD calculations based on user selection
• Calculate top and bottom n analysis for products based on sales and quantity based on user selection
• Allow users to dynamically change measures in the chart. Calculate sales, quantity and COGS for this.

[Korekar27]

Thanks

[amitchandak]

@Korekar27 , refer if this can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Get Super Dynamic TOPN using Window, Numeric, and Field parameters along with calculation groups- https://youtu.be/YW1SOk9V9xk