Skip to Content

How to fix columns in crosstab irrespective of data

Feb 20, 2017 at 01:49 PM


avatar image
Former Member

I have a cross table as attached in a webi report.

Here Employee object is taken in row and Month object in column. PM(Previous Month) and MTD(Current Month) are displayed over Month name using conditional formatting. If data is not there for current Month, then only PM column will be displayed.I got a requirement to fix the number of columns to 2 even if data is there for one month. If I did any modifications on column to display PM/MTD, then data is not coming correctly for each employee. Please help me in this.

report.jpg (9.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Feb 21, 2017 at 04:50 PM


What do you mean data is not populated correctly when you apply any changes to the column?.

Can you post a scenario please?.



10 |10000 characters needed characters left characters exceeded