How to calculate the partial sum in pivot table that has aggr dimensions

[uacg0009]

Hi all,

I have data like below:

And I create a pivot table:

The final expression is what I want and I don't know how to do it.

I just want to calculate the total of invoice group by STAFF, but I think the aggr dimension affects the expression with aggr.

what I want is this:

I have used: aggr(count (distinct INVOICE),STAFF) and count(distinct <STAFF> INVOICE) they didn't work.

It just works some rows, I think it is because the dimension affects the aggr in expression.

Do you have any idea to solve this?

If you have any questions pls feel free to tell me.

Thank you so much!

[MK_QSL]

Unclear about your requirements.

Can you be more specific? Thanks

[sunilkumarqv]

Like these

Find attached

[uacg0009]

Hi Manish,

thank you for your reply, and sorry for that I haven't clarified what I want.

And I add a picture and some comments to show what I want above, If you have any question please tell me.

[uacg0009]

Hi sunil,

thank you for your reply, but I think it is not what I want.

I think maybe I haven't clarified what I want.

And now I modified it above, please check it and if you have any idea to solve it please tell me.