Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am plotting some data which are quarterly, like Q1'15, Q2.15, Q3'15,....................., Q1'16, Q2'16, Q3'16,....... and so on. For Q3'16 growth should be value of Q3'16 - Q3'15.
Please help on this .
Regards
PC
Hi Chinnu,
Are you generating the Q fields from a date field ? Or is it provided as it is in the source ?
A sample data will be helpful
Hi Jyothish,
Thank you for Quick response.
please find below for sample data.
Regards
PC
Hi Chinnu,
Try this:
Thank you.
I need YOY in the same table.
Is it possible in the pivot table ?
say example,
if we take year and quarter as dimension and sum(sales )as dimension.
If we expand year it will show 4 quarters Q1,Q2,Q3,Q4 sales for based on year wise.
I need to find same as previous year Q1,Q2,Q3,Q4,
if I will get this, I can easily find it out.
Regards
PC
Hi Chinnu,
Try this:
it's giving wrong YOY.
yoy should give.....
(2018(Sales) - 2017(Sales)) /2017(Sales)
Hi Chinnu,
I am not exactly clear on your requirement.
See this: