Multiple dimensions in a single bar chart

[#1]

Hi, Good afternoon

  I have a colection of data sorted by month and quarters, it is possible to have both dimensions in the same chart?, the idea goes like this:

  if month 1 is selected, the chart will display only that month (January)

  if month 2 is selected, the chart will display Jan and Feb, and in month 3, Jan, Feb and March

by month 4, i want it to display Q1, (the sum of Jan, Feb and Mar) and month April.

This means, for each 3 months passed, it replaces by 1 quarter of the year.

Thx for all any help.

[MayilVahanan · Accepted solution]

HI

PFA

May be it helps. Its one of the way to do it..

[#3]

THANK YOU A LOT

  This is exactly what i need, will use it with my data and see how it goes.