Percentoftotal for distinct id on pivot table fields across row and columns

Question & Answer
,
1

distinctCountOver({resourceID}, [{X-Axis Grouping}], PRE_AGG)/distinctCountOver({resourceID}, , PRE_AGG)
is not working
I have x axis groupings and y axis groupings as i am using pivot of fields

Any work arounds.?

2

Hi @locallaunda

welcome to the community :confetti_ball:

Can you provide more information? What is your error message?

There is a square in your formula. Is that correct?

Best regards,
Nico

3

Hi @locallaunda,
It’s been awhile since we last heard from you, are you still working on this issue or were you able to find a work around in the mean time?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!