2 Replies Latest reply: Nov 24, 2015 8:32 AM by Sunny Talwar

How to add Quarter as Dimensions & Bifurcation of cumulative balance

HI

I have data similar as below

Month     Amount

Jan          10

Feb          25

Mar          15

Apr          45

May         60

Jun          35

Jul            45

Aug          80

Sep          100

Oct          105

Nov          90

Dec          80

Q1: How I can add Quarter 1 (Jan -Mar) Q2 (Apr-Jun) Q3 and Q4 as Dimensions or in Coding as Fields

Q2: Above balances are cumulative balances, How I can bifurcate these balances as period balances for each month in Coding or in expression as formula to show in chart or table e.g For Feb Balance should be 25-10 = 15 vice versa

Regards

• Re: How to add Quarter as Dimensions & Bifurcation of cumulative balance

Balances can be negative also? Mar - Feb -> 15 - 25 = -10?

• Re: How to add Quarter as Dimensions & Bifurcation of cumulative balance

This?

Table:

Amount - Alt(Previous(Amount), 0) as [Period Balance];

'Q' & Ceil(Month/3) as Quarter;

Amount;

Month,    Amount

Jan,          10

Feb,          25

Mar,          15

Apr,          45

May,        60

Jun,          35

Jul,            45

Aug,          80

Sep,          100

Oct,          105

Nov,          90

Dec,          80

];