topic Re: previous year and current year data on a bar chart in App Development

previous year and current year data on a bar chart

Anonymous — Sat, 16 Nov 2024 08:52:09 GMT

I want to display the current and previous years data (by month) on a bar chart with the respective month columns side by side.

Below is some sample data I want to use,

Dimension = month , measures = DCIPU,

thanks in advance for your help

sunny_talwar — Thu, 18 Jan 2018 17:39:06 GMT

May be this

Current Year

Sum({<Year = {"$(=Max(Year))"}>}DCIPU)

Previous Year

Sum({<Year = {"$(=Max(Year)-1)"}>}DCIPU)

Anonymous — Fri, 19 Jan 2018 02:52:49 GMT

That worked fine, thanks a lot Sunny

sunny_talwar — Fri, 19 Jan 2018 09:14:29 GMT

Not a problem. Please close the thread by marking the correct response.

Best,

Sunny