Qliksense: Need YTD column in pivot table

[Anonymous]

Hi All,

I have a balance sheet to be displayed using a pivot table. So month is one of the dimension in columns and it has another dimension business units under it. So I need to get a YTD column with Business units under it based on the month selected in the filter.

Can someone help me out on this.

[sunny_talwar]

Would you be able to share a sample or sample data and point out the desired output from the sample provided?

[Anonymous]

Hi Sunny,

Please find  the attached excel for the sample data and requirement.

[sunny_talwar · Accepted solution]

May be like the attached

[Anonymous]

Can you please explain how this is achieved.(how peek works here, and in the set expression works and that expression to sort) How YTD value is being calculated??