Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a pivot table where my row is
=IF(DT= 'Response',BU)
Column
=IF(DT= 'Response',SR)
My first measure is
Count(ID)
In the second measure, I am trying to calculate the percentage. Tried with 2 formula but both are not working
COUNT(TOTAL ID)
COUNT(TOTAL <row> ID)
Please help
Try like below
Count(ID)/
COUNT({<DT={ 'Response'}>}TOTAL ID)
Maye be likek :
=num(count(ID)/count(total ID),'#,##0.0%')
or you can share a sample data and the expected output
Not working.
I have a conditional row so may be thats the problem.
Try like below
Count(ID)/
COUNT({<DT={ 'Response'}>}TOTAL ID)
can you share sample data and the expected output ?
the conditional row formule