Skip to Content
author's profile photo
Former Member

Columns in reports

In the query designer in the columns box I place 4 values for the Key section and also 2 values from the Dimensions. Both the Dimension and Key Section are the values available in the far LHS long box.

I want them to appear on one header row but the Dimension come on the row above the Key values.

There is one value in the row which is a characteristic from which I use a hierarchy. Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Sep 30, 2005 at 12:34 PM

    Niten,

    Create calcualated keyfigure for the dimensions and put them in column box along with 4 keyfigures.

    this will works. let me know if any clarification.

    regs/mahantesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thats right, I do not want to display the Key fields as columns, just two Dimension fields and 4 Key Figures. Thanks for your help on this I think we are almost there!!