Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on a report, where i need to use results of a straight table into a pivot table.
The straight table is of the format:
YEARQTR FIELD1 Count(FIELD2)
2013Q1 A 1
2013Q1 B 2
2013Q2 A 3
2013Q3 C 1
2013Q3 B 4
2013Q4 A 5
so on...
I want to use the third column(Count(FIELD2)) from this table as a row in a pivot table, YEARQTR as a column, and count of FIELD1 as a measure.
Count(FIELD2) | 2013Q1 | 2013Q2 | 2013Q3 | 2013Q4 |
---|---|---|---|---|
count of FIELD2 for each FIELD1 1 | count of FIELD1 having counts of FIELD2 as 1 | count of FIELD1 having counts of FIELD2 as 1 | count of FIELD1 having counts of FIELD2 as 1 | count of FIELD1 having counts of FIELD2 as 1 |
count of FIELD2 for each FIELD1 2 | count of FIELD1 having counts of FIELD2 as 2 | count of FIELD1 having counts of FIELD2 as 2 | count of FIELD1 having counts of FIELD2 as 2 | count of FIELD1 having counts of FIELD2 as 2 |
count of FIELD2 for each FIELD1 3 | count of FIELD1 having counts of FIELD2 as 3 | count of FIELD1 having counts of FIELD2 as 3 | count of FIELD1 having counts of FIELD2 as 3 | count of FIELD1 having counts of FIELD2 as 3 |
I tried to load count(FIELD2) as field2, but didn't get the correct result. Please help me.
May be something like this -
Actually there are other fields too which i am pulling from excel. I tried with creating a new container using only the required 3 fields, and count(field2) as field2#. But the data isn't correct. I verified this by creating a straight table with the 3 columns and then used it in another app for the pivot table.