Webi Cross Tab Report in 4.1- Dates issue

building reports webintelligence legacy
1

Hi Experts,
I have a cross tab report in 4.1, output values in webi are as shown in the attachment. The Dates values ( Horizontal), Vertical values ( Names), Center values,these all are coming as dimensions from IDT, we cant change in IDT as we dont have access, we should do any changes in the report only.
My output should be like ( if center values are same always, for the single date)

                                                       5/6/14        5/7/14       5/8/14

Auto 10 1 0
CS_Ms-MDS 0 12 1
DQ_MS-MDS 12 0 0

My output should be like ( if center values are differing then, Dates should be shown as below:)

                    5/6/14  5/6/14  5/6/14  5/7/14  5/7/14   5/8/14   5/8/14

Auto 10 1 10 1 10 0 12
CS_MS-MDS 0 0 0 12 1 1 12
DQ_MS-MDS 12 10 12 0 12 0 1
a.zip (7.0 KB)

coll (BOB member since 2011-11-03)

2

the values, which you wish to be aggregated, should be set up as measures in the universe

erik.stenson :us: (BOB member since 2012-07-30)