RangeSum(Above(Exp)),...) Doesn't work on Transposed Pivot Table.

[ashish_2511]

Hi community

Here's the problem i'm facing -

I have a pivot table with a column called Total customers.

Total Customers = RangeSum(above(Count({<IsInYTD={1}>}current_account_id),0,4))

My actual requirement is to show the transposed form of the table but when I do so (by just dragging the dimensions to the top and Expressions to the left), The above expression doesn't work anymore and I get all zeroes.

Can Anybody suggest a workaround.

Normal Table (Working) -

Transposed Table (Not Working) -

Attached is the reduced QVW.

Regards

-Sneh

[Anonymous · Accepted solution]

Hi Sneh,

PFA. You have to use "Before" function.

Thanks,

Nisha

[Anil_Babu_Samineni]

It should help

https://community.qlik.com/docs/DOC-8242

Tell me, Expected O/P

[ashish_2511]

Thank you Nisha. that worked.

[ashish_2511]

Thanks Anil. This helped.