Removal of "-" value for the Dimension in Pivot Table

[#1]

Hi All,

I am currently facing the following issue.

My requirement is like a product sold in particular month and support is taken in the subsequent months. So i have to calculate the support rate being taken.

For e.g data is as shown below

Product Product Sold YM Product Amount Support taken YM Support amount

P1 200804 100 200804 10

P1 200804 100 200805 20

P1 200804 100 200806 30

Now my support rate for Product 200804 sold in 200804 = 10/100 = 10%

Now my support rate for Product 200805 sold in 200804 = 10+20/100 = 30%

Now my support rate for Product 200806 sold in 200804 = 10+20+30/100 = 60%

When i Display the Pivot table, my data would show as follows;

PP YM

200804

SS YM 200804 10%

200805 30%

200806 60%

But since SS YM has null values, it is displaying as

PP YM

200804

SS YM 200804 10%

200805 30%

200806 60%

- 100% --- I do not want this to be displayed.

If I do "Suppress NULL", then my calcualtions shown are

PP YM

200804

SS YM 200804 15%

200805 48%

200806 100% -- This is incorrect

Please let me know how can i remove the "-" without effecting the calculations!!.....

[#2]

Can you plzz share your application........

[#3]

I think this is showing your total of % .

please remove the No Totals from you expression. It will be removed.

I think this will work

[maneshkhottcpl]

Hi,

U can use if(isnull([SS YM]) or len([SS YM])<2,0,Your Expreson)

Or send me ur application.