Trial balance

[stephane_kosior]

Hi,

I'm trying to create a Pivot Chart with QV where I can build a trial balance by month

I have set the expression like this :

sum({<[Account Type]={'BS'},[Fiscal Year]={$(vYTDYear)}>} [Amount])

But I would like that the October column will sum the september column and the "activity" done in October. I tried the above function but without any success.

Could you please help me ?

[sunny_talwar · Accepted solution]

Since this is a pivot table... try using Before instead of Above

Missing Manual - Before() and After()

[stephane_kosior]

Many thanks Sunny Talwar.

It works fine ! I wan't aware of this function ... and I should !!

Many thanks again.