How to calculate sum for quarterly basis

[vipingarg23]

Hi Team,

Please find the dummy data as an attachment.

Requirement:

I have one dimension YearQuarter and two expression A1 and B1.

I want to calculate B1 expression in such a way that it should sum the data of A1 for 2016Q1, 2016Q2, 2016Q3, 2016Q4 and same for 2017 Quarter data. I want the B1 data as below:

YearQuarter	2016Q1	2016Q2	2016Q3	2016Q4	2017Q1	2017Q2	2017Q3	2017Q4
A1	5	7	9	13	4	18	20	22
B1				34				64

Please find the dummy data as an attachment. Can anybody give me the solution?

Thanks for your help!!!!!!!!!

[fvelascog72]

Hi,

Create a Year Field: Left(YearQuarter,4) as Year

Then in the expression use:

If(Right(YearQuarter,2)='Q4', Before(Sum(Aggr(Sum(Data), Year)), 3,1))

Saludos

[tresesco · Accepted solution]

Try this:

If(Right(YearQuarter,1)='4', RangeSum(Before(Sum(Data), 0,4)))

[vipingarg23]

Thanks for your help..

It is working fine.