Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
)
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))
)
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