Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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.
Hi Sony,
Sorry, i am not clear about your requirement, can you please explain again ?
Br,
KC
Hi Sony,
Check this:
and without Total in stacked Barchart check attached!
thank you
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?
So what will be your expected labels in next quarter ?
2019Q1 2019Q2 2019Q3 2019Q4 Beyond 2019Q4
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
thanks but as per my customer current quarter is 2018Q4 only ...