cancel
Showing results for 
Search instead for 
Did you mean: 

Cross table layout

former_member210043
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member211235
Active Participant
0 Kudos

Hi Nikhil,

Apply break on Area, Level and Location.

Hope this helps...!!!

Grtz

-Anila.

Former Member
0 Kudos

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

former_member210043
Participant
0 Kudos

Hi Rogerio ,

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

Thanks

Nikil

amitrathi239
Active Contributor
0 Kudos

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

former_member210043
Participant
0 Kudos

Hi Amit ,

Thanks  alot for the reply..please help me bit detail how to convert above vertical table to cross table(it is just turn it into cross table or any other seetings we need to do ) . i am new to usage of cross table .

Thanks

Regards ,

Nikil.

former_member210043
Participant
0 Kudos

Hi Amit ,

My cross table layout which i have attached is bit diffrent first 3  columns  , then we need to display the qtr1.2014,qtr2.2014, data respective to first three columns data .. plz observe my attached cross table layout..

Thanks

Regards,

NIkil..

amitrathi239
Active Contributor
0 Kudos

Hi,

Turn to cross-tab is the option to convert table data in the cross tab.For the first column apply break and merge the values.

if you will put your objects in similar way to my table display and convert ,you will get the same format as i have attached in the second screenshot.

Amit

former_member210043
Participant
0 Kudos


Hi Amit,

Thanks for the response.

Plzz check my original screen shot ,

What ever u suggested in u r  second screen shot is displaying the data in blue color(as left header) as header. to change the color i can do the format cell options.but the header for that data we need to get in blue color. if i am not conveying clearly plz check once my attached file. in original post..

Thanks

Nikil..

amitrathi239
Active Contributor
0 Kudos

Hi,

Select the cells->Format tab->Style->select the background colour white and font colour black.Even these formatting you can do by Format Painter also.similar to excel/outlook format painter.see second screenshot for format painter.

former_member210043
Participant
0 Kudos

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