Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In expressions
Sum({<Country-={'Japan'}>}value)
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)