How to display Overall Total Display at last row of cross tab?

[chandrasekhar6]

Hi Team

We have data source contains one field have hierarchy has contains 4 Levels:

Level0: Year

Level1: Month

LEvel2: Quarter

Level3: Week

You want to show the only Level1 data in a crosstab.

For the Level1, I have put filters in the edit initial view and show data only by Level1.

But my issue is, cross shows overall total at the top(1st), how to display at last row,

Design Studio version: 1.6 SP06 and Data Source: BW

Please help in the above issue.

Thanks,

Chandrasekhar

[sapna_jgurudutt]

Hi Chandrasekhar,

Can you clarify regarding if this issue while you execute the relevant query (which you are using as Datasource) directly from RSRT?

Also, can you clarify regarding the following mentioned as it is not clear:

"We have data source contains 5 levels of data, so we can display only Level2 data in the crosstab."

Thanks & Regards,

Sapna

[TammyPowlas · Accepted solution]

Hi - I changed the characteristic setting in the BEx query and it moved the overall results to the bottom - see below:

Position of lower level nodes to above

[chandrasekhar6 · Accepted solution]

Thank you Tammy