calculating the working days per month

[#1]

I want to calculate the working days for each route I have in my pivot table where the working days is not fixed from month to month. please see attached picture

[swuehl · Accepted solution]

I think you want an expression like

=Sum( If(RouteClosed=1,1,0))

evaluated in your partial sum, right?

You can use SecondaryDimensionality() to check if your expression is evaluated in a partial sum, something like

=If( SecondaryDimensionality() >1, /* might need to check if dimensionality is chosen correct for your application, check the HELP file for Dimensionality() and SecondaryDimensionality */

     If(RouteClosed=1,'Yes','No'),

     Sum( If(RouteClosed=1,1,0))

)

[ziadm]

Make your Route expression in the Pivot Table as below

if(RouteClosed= 1 ,Dual('Yes',1),Dual('No',0))

The make a new expression to sum your routes