display aggregated Data

[former_member539471]

Hello All,

Please see the below image . I created a cross tab report . I want to display  data for "Type " Column in aggregated way.

It shows pcp for every count , i just wanted it to sum count for every PCP value or PCP specialist value

I wnat the data to be diaplyed

Type                               PCount1      P Count 2

PCP                               206                  898

PCP specialist                  30                   33

I wrote a variable for  Pcount 1   = Sum(Count1) and Pcount2=  Sum(Count 2)

[former_member203850 · Accepted solution]

HI Pali ,

Anuj has already mentioned about the usage of dimension object in cross tab report .

In the above report , HR is a dimension object and count 1 & count 2 values segregated by dimension object.

Kindly remove dimension object from your cross tab report.

Regards,

Pranay

[former_member539471 · Accepted solution]

Hello Pranay,

I will need those dimension objects. I want the results to be displayed that way even in presence of Dimension objects.

Thanks.

[former_member203850 · Accepted solution]

Hi pali ,

Can you please let us know how you would like to display in report. Please mention some sample data for the above requirement.

Regards,

Pranay

[former_member539471 · Accepted solution]

Hello Pranay,

Please see the sample data ...how i am supposed to display data.

[Former Member · Accepted solution]

Hi Pali,

Please create report variable and define HR object as measure and you can pull that object in report.

~Anuj

[Former Member]

Hi,

Try These

1)    

Type(Dimension) |     PCount1     |     PCount2     |

PCP                  |   Sum(Count1) |  Sum(Count2) |

PCP Specialist   | 

2)

if you have only two(Limited) Types then

In Verticle Table

Type(Dimension) |     PCount1                                                    |     PCount2                                        |

PCP                  |   Sum(Count1 Where([Type]="PCP"))               |  Sum(Count2 Where([Type]="PCP")) |

PCP Specialist   |  Sum(Count1 Where([Type]="PCP Specialist")) |  Sum(Count2 Where([Type]="PCP Specialist"))                 |

[former_member539471]

Nikhil,

I am sure I understood .... you want me to write a variable for

Count 1 = Sum(Count1 Where([Type]="PCP"))  |  Sum(Count1 Where([Type]="PCP Specialist")) |

Count 2 =  |  Sum(Count2 Where([Type]="PCP")) ||  Sum(Count2 Where([Type]="PCP Specialist")) 

Thanks

[former_member539471]

I tried a variable with the below

Count 1=Concatenation(Sum([Count1] Where([ Type]="PCP"));Sum([Practice Count] Where([ Type]="PCP/Specialist")))

I am unable to sum st the end of the column since now it is a string. Is there a solution to this?

In any case it is still not aggregated the data like how i wanted it to.

Thanks.

[former_member539471]

Hello All,

This worked for me when I wrote a variable for all dimension objects in report with =SUM().

Thanks everyone for ur inputs.

[Former Member]

Hi Pali,

Please make sure Count1 and Count2 are measures object not dimension.

~Anuj

[former_member539471]

Hello Anuj,

Count 1 and COunt 2 are measures

Thanks.