QOQ growth

[chinnuchinni]

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

[jyothish8807]

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

[chinnuchinni]

Hi Jyothish,

Thank you for Quick response.

please find below for sample data.

Regards

PC

[jyothish8807]

 Hi Chinnu,

Try this:

[chinnuchinni]

Thank you.

I need YOY in the same table.

Is it possible in the pivot table ?

[chinnuchinni]

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

[jyothish8807]

Hi Chinnu,

Try this:

[chinnuchinni]

it's giving wrong YOY.

yoy should give.....

(2018(Sales) - 2017(Sales)) /2017(Sales)

[jyothish8807]

Hi Chinnu,

I am not exactly clear on your requirement.

See this: