Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!Hi Anyone,
I have the pivot table with totals now.
How can I get the percentage by programs?
I have added a expression =count([G-code])/Count(TOTAL [G-code]) but this gives the percentage by taking the overall total.
For example for G-Code A the percentage I want is 1/1=100% but the above expression gives 1/8 which is 0.125.
Any help?
I tried various combinations of Aggr (my level) but no use.
Thanks!
May be try this
=Count([G-code])/Count(TOTAL <Program> [G-code])
Please check the attachment.
Thanks @Sunny Talwar.
It worked.