Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want to restrict customer='siva' in dimension of pivot table
Ok, then I probably misunderstood you. I thought you wanted to see only the results for customer siva in the pivot table. If you want to see the results for every customer except customer siva then try expressions like:
sum({<customer-={'siva'}>}Sales)
sum({1-<customer={'siva'}>}Sales)
sum({<customer=E(<Customer={'siva'}>}Customer)>}Sales)
Add {<customer={'siva'}>} to all the expressions in your pivot table. For example sum(Sales) becomes sum({<customer={'siva'}>}Sales)
Hi Gysbert,
i want to customer siva in qvd but i don't want to see customer siva in the pivot table and his income and profit values also
i had used the expression for the income and profit but customer is in dimension.
Thanks
Ok, then I probably misunderstood you. I thought you wanted to see only the results for customer siva in the pivot table. If you want to see the results for every customer except customer siva then try expressions like:
sum({<customer-={'siva'}>}Sales)
sum({1-<customer={'siva'}>}Sales)
sum({<customer=E(<Customer={'siva'}>}Customer)>}Sales)