Finding Max in Expression in a chart.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement to identify the max of the ProjectID along with the Dimension selected. There are many dimensions (Year, Region, etc).

This is the sample data:

So it has to work like this:

If no year is selected, the data shown would be:

If the year is filtered as 2007, the data should be shown as

So the Filter/ column to be added in the chart is Dynamic.

Can you please suggest how to accomplish this requirement.

Thanks,

Re: Finding Max in Expression in a chart.

Clever_Anjos — Fri, 01 Sep 2017 19:25:59 GMT

Anonymous — Fri, 01 Sep 2017 19:45:48 GMT

Thanks it worked.