Help to add YTD & MTD in Pivot Table

[SatyaPaleti]

Hi Folks,

Could some one can please help me How can we add YTD & MTD in the bottom of the Pivot table.

I am showing Jul and August Sales and in September I have to show all the dates Sales. So I need two total at bottom one is Totals for all the months and one is Total for all the Days. As per below screenshot

Please find attached documents for sample qvw and sample data

Thanks and Regards,

Satya

[qliksus]

Just add dummy dimension  and use the below expression

Dim1 :  ''

Dime2 : Month  ............etc

Expr:    if( Dimensionality() = 1 , Sum({<Month={'Sep'}>}Sales) ,

           if( Dimensionality() = 0 , Sum({<Month=-{'Sep'}>}Sales) ,
sum(Sales) ) )

You can use dynamic month based on your requirement in the filter

[uacg0009]

Hi Satya,

For pivot table, there is function in Presentation tab called show partial sums.

You can check it in your month and Date column, then you will see the total that you need.

Thanks.

Aiolos

[SatyaPaleti]

Hi Susanth,

Thank your reply.  Can you please create sample qvw and forward to me

Thanks and Regards,

Satya