Dear All,
I need to display the null value in the sub team @ the bottom of the pivot table ,i have tried out the sorting option but it is not working ,kindly help me out on this !!
Current Result
| Business Unit | Sub Team | Brand |
| Total | | |
| YYYY | | Total |
| YYYY | | a |
| YYYY | | b |
| YYYY | | c |
| YYYY | | d |
| YYYY | Bien-etre | Total |
| YYYY | Bien-etre | A |
| YYYY | Bien-etre | B |
| YYYY | Bien-etre | C |
| YYYY | Bien-etre | D |
Expected Result
| Business Unit | Sub Team | Brand |
| Total | | |
| YYYY | Bien-etre | Total |
| YYYY | Bien-etre | A |
| YYYY | Bien-etre | B |
| YYYY | Bien-etre | C |
| YYYY | Bien-etre | D |
| YYYY | | Total |
| YYYY | | a |
| YYYY | | b |
| YYYY | | c |
Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
