Skip to Content

Webi formatting a cross tab and repeating values

Please refer to the image attached.

Hi Experts,

I'm creating a cross tab report and am completely lost on how to achieve the following :

1) Repeating the MTH of Year on each columns(unlike the table in the attachment) like :

Oct2013 OCT2013 Nov2013 Nov2013 Dec2013 Dec2013

GrossSales Quantity Gross sales Quantity Gross sales Quantity

I really thought this would be a simple formatting option (or may be it is) I can't seem to figure out a way to accomplish this. Although,I'm able to merge the two cells together so each MTH value represents two columns but i want individual values for each column repeated like the example above.

2) Arranging the measures one after the other like :

Oct2013 Nov2013 Dec2013 Oct2013 Nov2013 Dec2013

GrossSales GrossSales GrossSales Quantity Quantity Quantity

So, I'm trying to display GrossSales for all the months first and then Quantity for all the months.

Please let me know if more details are required on this .

Thanks

GD Bhatt

Capture.png (15.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2014 at 07:16 PM

    1) Repeating the MTH of Year on each columns(unlike the table in the attachment) like :

    Oct2013 OCT2013 Nov2013 Nov2013 Dec2013 Dec2013

    GrossSales Quantity Gross sales Quantity Gross sales Quantity

    Just drag and drop the same object that is present above GrossSales cell to the blank cell after it (the one above Quantity).

    2) Arranging the measures one after the other like :

    Oct2013 Nov2013 Dec2013 Oct2013 Nov2013 Dec2013

    GrossSales GrossSales GrossSales Quantity Quantity Quantity

    Create two cross tabs. One with GrossSales and another with Quantity (Then delete the first column). And set the horizontal relative position so that it looks like one cross tab.


    untitled.PNG (15.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gaurav Bhatt

      Hi Gaurav,

      The only way to do it would be 2 convert the GrossSales and Quantity from Column to Rows.

      The way I did was to create two queries with UNION like below:-

      YearMonth, GrossSales, 'GrossSales' Flag1

      UNION

      YearMonth, Quantity, 'Quantity' Flag2

      Please note you might have to create 2 Flag objects in Universe or do custom SQL.

      Then create a crosstab with below details:-

      Horizontal Axis : YearMonth

      Flag

      Body Axis: GrossSales

      Then do a sort on the Flag column. Pls refer to the screenshot on a sample I created from eFashion.

      Regards,

      Kashif

  • Jan 15, 2014 at 03:08 PM

    Hi,

    Did you tried pulling Gross sales dimension on 1st row of the crosstab table and then the Months in 2nd row and add Gross sales dimension 3rd row.

    Hide 1st row.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2014 at 08:06 AM

    Hi,

    this is workaround i once did try if it works in your case

    make a cross tab1 based on gross sales and make a copy of the cross tab1 next to the cross tab 2 and change the parameter of the cross tab as quantity. and maintain both cross tabs 1 and 2(hide row labels of cross tab at the back of cross tab 1)

    hope this helps,

    Regards,

    Sundar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2016 at 03:37 PM

    Hi All,

    I am facing the requirement.

    Is it possible in single cross tab itself?


    Thanks,

    Murugan S

    Add comment
    10|10000 characters needed characters exceeded