Separate bar

[soniasweety]

Hi all,

Jyothish KC

franky_h79

i have a bar chart with all the quarters   .

but my requirment is   i want to show  2018Q4 2019Q1,2019Q2,2019Q3  and beyond 2019Q3     means 2019Q4 2020Q1 2020Q2 ...till last quarter as separate bar.  as shown in image, !

in attached qvw  - first sheet first chart i need to show like below.

[jyothish8807]

Hi Sony,

Sorry, i am not clear about your requirement, can you please explain again ?

Br,

KC

[jyothish8807]

Hi Sony,

Check this:

[jyothish8807]

[Frank_Hartmann]

and without Total in stacked Barchart check attached!

[soniasweety]

thank you 

franky_h79

jyothish8807   but      "  can we make this dynamic?   bcz if i move to next quarter 

again i need to change the calucalted dimension right?  

how can w handle this?

[jyothish8807]

So what will be your expected labels in next quarter ?

[soniasweety]

2019Q1 2019Q2 2019Q3 2019Q4  Beyond 2019Q4

[jyothish8807]

Try this:

=if(Fiscal_Period > Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),'Beyond '& Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),

if(Fiscal_Period>= Year(today())&'Q'&ceil(month(today())/3),Fiscal_Period))

As per the logic the dimension will start from 2018Q3 (Current Quarter) but you do not have data for this quarter, so it will start from 2018Q4

Br,

KC

[soniasweety]

thanks but  as per my customer  current quarter is  2018Q4 only ...