Header for the reporting

[praneshsapmm]

Hello All ,

I have this requirement to generate the report with below header : 

XXX	2019	2020Q1	2020Q2	2020/06	2020/07
A	1	1	1	1	1
B	2	2	2	2	2
C	3	3	3	3	3
D	4	4	4	4	4
Grand total

The header changes whenever there is a new month added for example : 2020/08 is next . 

How to make it possible . Since there values are not constant iam unable to summerize and display the value in grand total .

Any help . 

Thanks

[atcodedog05 · Accepted solution]

Hi @praneshsapmm 

Since i am away from system I can just give a pointer till the next person replies.

Try transpose on transpose columns turns to rows. Next use grouby and then sum by summarize later you can cross tab once that's done. Crosstab it and union back with other rows.

[BrianR · Accepted solution]

Hi @praneshsapmm,

Here's an example, similar to one that @atcodedog05 was referring to. In this example, I'm using the report layout listed, and the first step is to transpose...this may look similar to your original input data, i.e., transactional rows of data for different time periods. One of the capabilities of the transpose tool is the Dynamic or Unknown Columns, so that will be able to account for new time periods, such as 2020/08. Then when you use a Cross Tab right after, one of the capabilities is to include a Total Row (or Total Column if desired). Take a look at the attached.