Use Straight table results in Pivot table.

[#1]

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.

[Digvijay_Singh]

May be something like this -

[#3]

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.