Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have a Dimension called Asset as shown in the image here. I am doing a sum(value) in a pivot chart for this dimension. I want to drop off or avoid showing the 3 fields highlighted as seen below from this Pivot chart... Is that possible by Set Analysis or any othe way as i cannot delete them from the source file...
Thanks in advance
The minus should be outside the brackets and just before the equals:
=num(sum({<[Assets]-= {'Whole Book'}, year = {'2011'}>}MTDTable), DataFormat)
For set analysis you would add {<[Assets-={'Fees','VAT on fees','Whole Book'}>} to your sum(value).
I know that, but what if i want to avoid them or ignore them... from calculating???
Thanks for your fast reply,
Mady
The minus sign in front of the equals in the set analysis will exclude those assets from being included in the calculation, and therefore would drop those dimensions from the pivot table.
=num(sum({<[Assets- ]= {'Whole Book'}, year = {'2011'}>}MTDTable), DataFormat) I have somethig like seen here... so here I used the - sign as suggested by you and it doesnt seem to work???...
Can you explain more please... Thanks Again
The minus should be outside the brackets and just before the equals:
=num(sum({<[Assets]-= {'Whole Book'}, year = {'2011'}>}MTDTable), DataFormat)
Thank you for all the help and your time 🙂
Hello further to the issue mentioned here, what if I want to remove these fields at the load script level, so that they are not used anywhere in the application?? They are coming from the SQL Table, Dashboard, Assets: I have the below load script.
Dashboard:
Load
Assets,
Profits,
Budget,
Other tables
From dbo.xyz table.
Thanks Again
You can just add a where clause to your SQL statment:
WHERE Assets <> 'Fees' and Assets <> 'VAT on fees' and Assets <> 'Whole Book'