Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geniuses,
I have a problem which needs your attention
I have a excel file in which year, quarter and month and forecast values are coming ,below is a sample
1 | Q1 | 2019 | 2019-Q1 | APJ | 81002 |
2 | Q1 | 2019 | 2019-Q1 | APJ | 74571 |
3 | Q1 | 2019 | 2019-Q1 | APJ | 76198 |
4 | Q2 | 2019 | 2019-Q2 | APJ | 66504 |
5 | Q2 | 2019 | 2019-Q2 | APJ | 73966 |
6 | Q2 | 2019 | 2019-Q2 | APJ | 98398 |
I want a chart in such a way that my dimension will be quater year and it should display the maximum month value so the result set look like below
2019-Q1 --> 76198
2019-Q2 --> 98398
I am attaching the complete excel please help me to create the chart
Thanks,
Shashank
Hi,
If you use "quater year "in Dimension then using "max(TOTAL_COMPT_LOCAL_AMT)" will give max amt under each quater year.
Please let me know if I missed to understand complexity in your problem