Skip to Content
avatar image
Former Member

Hiding Rows

Hi,

I made a drilldown on "Sales region" in the interactive planning , and I want to hide some rows in the "Total" than the details. Is this can be achieved by a Macro? Any onw knows about this?

Eg. Drill down creates the following data

Total

- Total Demand

- Total Supply

- Orders

Europe

- Total Demand

- Total Supply

- Orders

APAC

- Total Demand

- Total Supply

- Orders

I want to show only "Total Demand" in the "Total" is that possible?

/Shibu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 20, 2007 at 02:48 PM

    Did you try using the ROW_VISIBLE() function in Macros that gets invoked on drilldown on a charactersitic ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I found a solution to this problem. First keep the keyfigure as "Hidden" in the dataview design. Run a macro at the "Detailed" level and check if aggregation leve is =0 then make the row visible. I hope this helps some one..

      /Shibu