Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have my pivot table in this form
But I need it in this form
Loyality | NoLoyality | Total | Loyality | NoLoyality | Total |
Perc | Perc | Sale | Perc | Perc | Sale |
40% | 60% | 558,588 | 42% | 58% | 603,816 |
44% | 56% | 145,166 | 45% | 55% | 165,081 |
50% | 50% | 38,166 | 50% | 50% | 51,720 |
53% | 47% | 11,986 | 53% | 47% | 14,053 |
Total comes using show partial sum, but it shows in % as Perc is in %, but I want it in numbers.
Plz solve this problem
Thanking You
what is the problem here.
Sorry I think by mistake information is deleted.
My required table form is
Loyality | NoLoyality | Total | Loyality | NoLoyality | Total |
perc | perc | Sale | Perc | Perc | Sale |
40% | 60% | 558,588 | 42% | 58% | 603,816 |
44% | 56% | 145,166 | 45% | 55% | 165,081 |
50% | 50% | 38,166 | 50% | 50% | 51,720 |
53% | 47% | 11,986 | 53% | 47% | 14,053 |
If I am using partial sum then total comes in % but my need is in numbers