Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a project requirement like:
I have one straight table/Pivot table fully expanded and without any selection. When we do some selections the size of table gets reduced. But My requirement is, if we make some selections number of rows should not be affected i.e. the data relevant to selection should show the values and values of the dimensions values which are not related to selection should show 0.
If somebody has work around such requirement, please help me
Thanks a lot.
please post a sample application
thanks
regards
Marco
Hi Macro,
Apologies for late response.
I am trying to explain it through screenshots. I have attached the sample file too.
in your expression nullify selections.
For Ex. Sum({1}SalaryField)
Else Sum({<Location=,Office=>}SalaryField)
Use and Modify it according to your current expression
Hi Sraddha,
Here we have to enable the selections and all the dimension values should come in the table and calculation should be changes according to the selection(if it comes in the selected filter category) or 0.
In your case there will be no impact of selections on expression value.