Dynamic total issue

[#1]

Hello ,

     I want total like

segement                 plant                     location Code

M1                                        pune                                12

                                            Nashi k                            44

                                            M1 Total

M2                                     mumbai                              58         

                                             thane                                  54

                                            M2 Total.

M3                                        nagpur                              45

                                             M3 Total

T have tried it in presentation tab inthis way "=SEGMENT & 'Ext / Internal Total' " but it's not working

Pls Help .

[Gysbert_Wassenaar]

That's not possible. But maybe you can try this trick.

[kumarnatarajan]

Hi,

it is possible in pivot table. find the attached file