Retaining Table structure same even on making selections.

[anshulsri]

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.

[MarcoWedel]

please post a sample application

thanks

regards

Marco

[anshulsri]

Hi Macro,

Apologies for late response.

I am trying to explain it through screenshots. I have attached the sample file too.

  

[shraddha_g]

in your expression nullify selections.

For Ex. Sum({1}SalaryField)

Else Sum({<Location=,Office=>}SalaryField)

Use and Modify it according to your current expression

[anshulsri]

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.