Displaying a File Value against a selection

[#1]

Hi

I have a scenario where I need to display a Dimension against a selection. Its like displaying a Sequence No (which is a field) which I need to display against a selection (eg., Month = Jan) then Sequence (which has values A, B, C etc.  Can someone help me out on how to show this?

Below is the example which I would like to display.

Year     Person Name     Sum(Amount)     Sequence (Jan)     Sequence (Feb)     Sequence(Mar)

2016     XYZ                    5000                    A                              C                         B

2016     123                      7000                   C                              B                         A

Cheers!

Balaji Ramakrishnan. 

[swuehl]

How does your data model or input data look like?

Maybe have a look at

The Crosstable Load

if you need to transform your data from a crosstable to a straight table.