Skip to Content
avatar image
Former Member

Cross table layout

Hi Experts ,

How can create below attached webi report layout using cross table .and quaters for each year. i think it may b simple but i need u r help .

Help me....

Thanks ...

Regards,

Nikil

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Oct 21, 2015 at 02:14 PM

    Hi,

    where is the issue.

    You can display Quarter by Quarter function.

    sample =Quarter(ToDate([Month];"MM"))+"."+[Year]

    see attached screenshot.similar i have created on efashion data.

    First create a table like this and later convert to cross tab.

    Amit


    1.png (30.0 kB)
    2.png (38.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR

      Hi Amit,

      Thanks alotttt for the reply, i have done as u suggested. now I got as I need . it may b simple but for me it took some time .

      Once again Thanks..... 😊...

      Regards,

      Nikil

  • avatar image
    Former Member
    Oct 21, 2015 at 02:30 PM

    Hi Nikil,

    try this :

    1 - Create your Quarter object concatenating [Quarter]+"."+[Year}

    2 - Create your cross table with all dimensions Area, Level, location on rows and your quarter objects and the other dimension as columns;

    3 - Apply a break on quarter

    4 - format the break as shown in the below image :

    5 - format the Area as well.

    Regards,

    Rogerio


    break.png (24.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rogerio ,

      Thanks for the Response , helpful .. . plz check once my original attached file . help me in that exact format..

      Thanks

      Nikil

  • Oct 26, 2015 at 09:30 AM

    Hi Nikhil,

    Apply break on Area, Level and Location.

    Hope this helps...!!!

    Grtz

    -Anila.

    Add comment
    10|10000 characters needed characters exceeded