Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MTD Calculation

How can I put the expression to calculate MTD? I have the following columns in the pivot table:-

Column 1 - Day ( 1, 2, 3, ... , 31)

Column 2 - Office

Column 3 - Daily Sales

Column 4 - MTD Sales (from day 1 to the day in column 1 above)

1 Reply
Not applicable
Author

Hi,

Use above ( total .....) function.

Like

sum ( above ( total sales ) )

Reg,

Shubhu