How to display Nested columns in Straight table?

[#1]

Hi All,

I need to display nested columns in My Straight table ? With example i need? Help me.

[aveeeeeee7en]

Use Pivot Table

In Straight Table you can' do Subgrouping.

You can only achieve below result in Straight Table. See Snapshot:

You have to individual Field Expressions for each State. Like this:

Dimension = Date

Expression=

1) Sum({<Country={'USA'}>}Amount)

1) Sum({<Country={'IND'}>}Amount)

1) Sum({<Country={'JPN'}>}Amount)

1) Sum({<Country={'UK'}>}Amount)

Hope that helps.

Regards

Av7eN

[jagan]

Hi,

Grouping is not possible in Straight Table, if you have static number of values Country then you can write separate expressions refer above post for this.

Why you are not looking for Pivot table, if you able to provide the sample will try this in Pivot table.

Regards,

Jagan.

[#4]

Hi Av7en,

Can u explain more abot this.

[#5]

Let me know your Email ID Jagan?

[aveeeeeee7en]

See the Attachments.

Regards

Av7eN