on 06-30-2015 3:51 PM
Hi All,
I have created variable like below....
=If([Type]="A";"TypeA";If([Group]="B";"TypeB"))
Then below is the data displaying in crosstable
Group/Type | TypeA | TypeB | |
GA | 5 | 10 | 2 |
GB | 8 | 4 | 6 |
GC | 3 |
When I use the filter... Type is not null then it is displaying
Group/Type | TypeA | TypeB |
GA | 5 | 10 |
GB | 8 | 4 |
But i am expecting below data (all values should display eventhough respective KF's are null or 0)
Group/Type | TypeA | TypeB |
GA | 5 | 10 |
GB | 8 | 4 |
GC |
I already tried below work around options, but still no luck... 😞
- checked all the 'show' options in format table,
- Also tried with formula......if(isnull([KF]);0;[KF])
- Created query2 without KF and merged on 'Group'and then created new variable on merged object '[Group]'
Could you please help me if we have any work around to display all dimension values......
Note: Datasource is BEx query and webi4.1
Thank you,
Ranjith
which filter you are applying on table?
Thanks,
swapnil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
I have applied that rule for both Type and KF... now type 'blank' column is displaying in white and without border..it is fine
But since we have values for type 'blank', so width is not reducing for that blank column.
I am not sure how type 'blank' width is reduced in your screenshot..
Could you please give more details...
Thank you again,
Ranjith
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.