pivot exclude

[#1]

Hi Team,

I have Country { India, UK, US, Japan}. In pivot chart I have added country column as a Dimensions. I want to exclude 'Japan' value.

Now pivot shows:

India 50

UK    70

US    40

Japan 90

Total 250

It should show

India 50

UK    70

US    40

Total 160

Please help

[surendraj]

In expressions

Sum({<Country-={'Japan'}>}value)

[Anil_Babu_Samineni]

May be you can use in Script

Directory:

Load * Inline [

Country, sales

India, 50

UK,    70

US,    40

Japan, 90

Total, 250

];

Load Country, sales Resident Directory where Country <> 'Japan';

Or Object is this formalities

Dim as Country

And expression

Sum({<Country -= {'Japan'}>}sales)