Issue With Data

[NavinReddy]

Dear All,

I have Excel Data in That i have Fields are Separated like(JAN,FB,MAR,APR)

How can i Set Those fields in One Field Under Month

If i apply filter on month all Fields JAN,FEB,MAR,APR ...........should come under month Field

i have Two Types of Data there Dollars and SQF

Jan Actual Dollars,Feb Actual Dollars,Mar Actual Dollars...........etc

Jan Actual SQF,Feb Actual SQF,Mar Actual SQF.........etc

Please Create Month1 All Dollars,

and Month2 is All SQF

I am atteching Excel Dump Please some one create QVW it better for me under standing

i want to create chart like this

I hope some one will help on this issue

Thanks In Advance

Niranjan

[NavinReddy]

Guys Any idea

i found this code but i cant able to edit this

i am getting error

[Anonymous · Accepted solution]

Hi, Niru Niru.

Crosstable is the way to go. Here is an example QVW with your data showing how to do it. I'm going to attach the same file to your other posts about this issue too.

Cheers!