Issue in Pivot table

[nareshthavidishetty]

hi all,

please find the below screen shot, My requirement is like.

I have the data like

i want to show these values in pivot table like  below screen shot order should be(A,B,C,D).

But,when i am trying to do this ,it is showing like below screen shot

t

Can you please help on these guys.

warm Regards,

Naresh

[krishna_2644]

Try a Straight table if you dont want pivot properties.

[sinanozdemir]

Maybe something like this:

I am attaching the qvw in case.

[nareshthavidishetty]

Hi Sinan,

Thanks for your reply,

I am looking data like this only,but in qvw i am not able to find pivot table in front end like this.

Please provide me logic what you have done like this completely in QVW.

Warm Regards,

Naresh

[sinanozdemir]

You should be able to open up my qvw which I previously attached. Although, here are the steps to get a pivot table like this:

1. Bring the dimension A, and in the label put the below expression and also change the text color to white:

      

        

    2. Bring dimension B and put the below expression in the label box:

         

  3. Add a calculated dimension as shown below to get the overall totals and label it as ST:

          

   4. And lastly, in the expression, add the below Sum() expression and the label expression is =chr(10). After that drag the calculated        column to the top.

             

Hope this helps.

[nareshthavidishetty]

Tanks for you  quickresponse ,

But my data is like

A	B	C	D
1	8/1/2015	ST	488
1	8/2/2015	ST	283
1	8/3/2015	ST	705
1	8/4/2015	ST	512
1	8/5/2015	ST	471
2	8/1/2015	BT	100
2	8/2/2015	BT	100
2	8/3/2015	BT	100
2	8/4/2015	BT	100
2	8/5/2015	BT	100

problem is, the Data in  'C' Column will continue Like(ST,BT,TT,MtT)

Warm Regards,

Naresh

[nareshthavidishetty]

Hi Sinan,

I am looking like this,

Regards,

Naresh

[nareshthavidishetty]

Hi sinan,

I am looking like this,Including column names(A,B,C,D)please find below screen shot.

Warms Regards,

Naresh

[sinanozdemir]

This is as close as I can get:

If this is not, what you are after then you may need to create some additional dimensions in the load script.