How to show the columes for week wise like Class ID 02/10/2013 02/17/2013 02/24/2013 03/03/2013

[Former Member]

Hi,

How to show the columns in each week wise in the webi report ..?

Class ID	02/10/2013	02/17/2013	02/24/2013	03/03/2013
101	99.33	99.5	95.66	85.55

Please give me any guides please

Regards

sridhar

[former_member198519]

If I understood it correctly you need to show the measure value week on week rather then date on date. If thats is correct, this is what you need to do

[Week]=Week([Date Object])

Create a crosstab with [Class ID] and [Week]. The output will look something like the below screenshot.

Let us know if you are expecting something different.

[Former Member]

Do you want only the value for that day of the week or the value of the entire week summed up and showed against the start date of the week?

[Former Member]

Hi,

Thank you for responses..

But my requirements is like

   Class ID   02/10/2013   02/17/2013   02/24/2013   03/03/2013…

    101           22.5                  2542                55.55                25.55

    ----                 ---                    ---                    ----                         ---

   107               25..5               25.6                    33.5               55.5

So i need only 7days column  for each

Thank you..

[Former Member]

Yes i want to only every week wise for columns

[former_member198519]

Unfortunately, I am failing to get what you want? Would you elaborate it further?

[former_member198519]

is this what you require to show?

[Former Member]

Hi,

Please see this mail attached

Class ID	Subclass	02/10/2013	02/17/2013	02/24/2013	03/03/2013
386	155	99.92%
386	160	99.95%
403	626			98.24%
403	627	99.87%	99.91%
403	631		99.79%	99.80%
403	635	86.33%
492	2400		80.07%	99.98%
492	2408	84.50%	99.89%	100.00%
492	2409	98.10%	88.66%
492	2410	99.81%

[former_member198519]

Which mail attached?

and looking at the what you presented, you can simply get this data by using a Crosstab. Try creating a crosstab for the same.

[Former Member]

OK Deep,

I will try ..