Scripting or chart logic required

[Anonymous]

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

[santhiqlik]

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