Skip to Content

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

3 Answers

  • Posted on 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

  • author's profile photo Former Member
    Former Member
    Posted on 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

  • Posted on 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