This discussion is archived
1 Reply Latest reply: Sep 17, 2013 8:42 PM by ca5037b8-b680-4974-8f29-d85c73fe1687 RSS

pivot view display

1012730 Explorer
Currently Being Moderated

in the pivot view  i have a requirement where the country name should be displayed for each row

 

rows                                                   measures

                                                                    sales

country      states

 

 

current output:

 

 

india        MP                             10

               AP                              20

               HP                               30

               Karnataka                     40

 

US           TX                                50

                NY                               60

 

 

Required output:

india                MP                             10

india                AP                              20

india                HP                               30

india                Karnataka                     40

 

US                 TX                                50

US                 NY                               60

 

can anyone tell me how to achieve this?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points