Skip to Content
avatar image
Former Member

How to Avoid column suppression

Dear All,

I have a scenario where coloumn is getting suppressed when i filter market area in y axis in cross tab as shown in image, but that should not happen, even if the corresponding dimension value is not there in data base it should show blank in that cell, as in image, your idea is much appreciated.

What I mean to say is when you filter dimension in y axis to non market area, BDGS and BMAS getting suppressed as in imange 2 but it show blank as per my need please do help. Only BNEW and BTEB is showing instead of as image 2. Please do help.

capture.png (14.9 kB)
capture.png (7.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 05, 2017 at 09:24 AM

    right click on the crosstab->format table and uncheck options Show rows or columns and try.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2017 at 09:19 AM

    Hi,

    duplicate the query
    merge dimension (BNEW, BMAS,..) from query1 and query2, and insert into the column header.

    Other objects in the table and filter from the query 1

    Add comment
    10|10000 characters needed characters exceeded