Expression promoting in pivot

[#1]

Hi all,

           i am faceing problem with expression in pivot .i want to promote exp(sales) in pivot.my requriement is

CUST     MONTH    SALES
A            JAN         100

B           JAN          200

            TOTAL       300

D          FEB          500

E          FEB          200

           TOTAL       700

I WANT TO O/P like this:

sales     CUST     MONTH    
  100              A            JAN       

  200               B           JAN        

300            TOTAL     

500              D          FEB         

200              E          FEB        

700           TOTAL     

plz help me on this.

regards,

rk

[Gysbert_Wassenaar]

That's not possible in a pivot table afaik. The dimensions are always shown on the left side (or on top if you pivot them) and the expression on the right side.

[#3]

Hi Gysbert,

                   Thanks for ur quick reply,Is there any possible to add the one new dimension at first ,it shows the led's like red,green symbols based on sales exp.

Thanks ,

Rk.

[Gysbert_Wassenaar]

No, only expressions can be shown as leds. But you can give the dimension values a different background color based on the value of the expression. Click on the + in front of the dimension, select Background Color and click on the Edit button to open the expression editor to enter an expression that calculates the color. For example:

if(sum(SALES)>400, green(), if(sum(SALES)>200, blue(), red()))