pivot table issue

[antonybi]

Hi,

I have created pivot table with

Rows-->Product

Rows---> Category

and

column--->Type

and

measure--> Sum(Sales)

after, it is showing as below snapshot.

So here, help me to remove the gray colour as it is too much irritating.I want to show it in white colour.

any help will be appreciated..

Thanks in advance!!!

PFB for your reference!!!

[antonybi]

Yes yes...I agreed.

can we find any other extension to accomplish this or by editing Jscript??

[Chanty4u]

i dont think so as of now no.

[sarahplymale]

You could try to use an outer join in your load script and then use something life if(isnull(value), 0, value) so that the null values are 0's instead of nulls.  That will make all those areas show in white with a 0 instead of grey with a '-'. It will greatly expand the size of your data model, but if it isn't large to begin with maybe that is acceptable.