Forum Discussion
undefined
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.
2 Replies
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
Thanks
