format the pivot table

[#1]

Header 1	dimension1Value1		dimension1Value2
	set analysis1	set analysis2	set analysis1	set analysis2
dimension2Value1	-	90%	-	90%
dimension2Value2	80%	-	70%	-

There're two dimensions:dimension1 and dimension2,

            two set analysis:set analysis1,set analysis2

Then in the pivot table ,the result is just like the table before.

But I want it to show like this :

	dimension1Value1	dimension1Value2
dimension2Value1	90%	90%
dimension2Value2	80%	70%

Anyone can help?

Thank you!

[jagan]

Hi,

Use one expression like this instead of 2 expressions

=If(Expression1 >0, Expression1, Expression2)

=If(Sum(Sales1) > 0, Sum(Sales1), Sum(Sales2))

Hope this helps you.

Regards,

Jagan.