How to display cross tabular data in straight table ?

[ashok1203]

Hi, i want to display the data in cross tabular format in straight table.For reference see the attachment.

[Anonymous]

How about using a Pivot Table with the Always Fully Expanded option ticked to it looks like a Straight Table

[Anonymous]

you Need to define 12 expressions (for each month one and use set Analysis in each Expression)

sum({<Month={'Jan'}>}Sales

and so forth

I would do this Job only if customer really Needs it and Pivot table is not possible or allowed

[Anonymous]

Hi!

Why you dont want use a pivot like this?

Regards.

[ashok1203]

You just specify how we do above scenario in pivot?

[Anonymous]

As I do in the file that you can find in my post you do this:

- create a pivot table ad insert Year and Month in dimension, sum(sales) in expression,

- drag and drop Month from column to row;

- in the presentation tab of the pivot table select Year (NOT Month) dimension and tyck Show Partial Total:

[ashok1203]

Thanks for Reply. Is their any way in straight tables except set expressions.

[Anonymous]

I think that you should use set expression in the straight table.