Sum of values, where value=1

[Anonymous]

Good day!

In attached model in pivot table TASK calculate count of Date, where quantity>0. And now i want to calculate sum of "1" (where quantity>0) by Spoint

But i need to do this not by deleting of DATE dimension or using in toolbox option TOTAL.

I need to do this by expression.

Best regards

[Gysbert_Wassenaar]

Try enabling the Partial Sums option for the Date dimension on the Presentation tab. Or is that what you mean with the TOTAL from the toolbox? If so perhaps you want this expression: sum(total <Spoint> aggr(count({<Quantity={'>0'}>}DISTINCT Date),Date,Spoint))

[JonnyPoole]

You can try enabling 'partial sum' on the presentation tab of the pivot table chart properties. That will show the totals of the '1s'. 

If that is not what you want, perhaps  you could create a sample of the end result you want in Excel and share it as i'm not 100% certain what you need.

[Anonymous]

No...My expression, which calculate "1", include IF expression.

That's why i'm looking for some way to sum this "1".

[Gysbert_Wassenaar]

Sum how? Over which dimension or dimensions? Post an example of what the result looks like.

[#6]

See attached

While I admit this is not the most flexible way to do this, I think this is what you were looking for.