Chart Presentation

[vanderson009]

Hello Community,

I have sample data as like below.

LOAD * Inline [

TouchPoint, Date, ResponseNo

billing, 07/01/2014, 123

billing, 06/01/2014, 234

billing, 05/01/2014, 345

billing, 04/01/2014, 453

devices, 07/01/2014, 345

devices, 06/01/2014, 234

devices, 05/01/2014, 342

devices, 04/01/2014, 546

network, 07/01/2014, 466

network, 06/01/2014, 654

network, 05/01/2014, 456

network, 04/01/2014, 567

online, 07/01/2014, 345

online, 06/01/2014, 342

online, 05/01/2014, 245

online, 04/01/2014, 543

];

By using this data i want output as like Table 02 but by default i get out put as like Table 01.

-- Thanks in advance

Villyee

[ThornOfCrowns]

What are the columns in Table02?

Specifically, what is the relationship of the single MonthName to your data - it isn't Max or Min - and what is that figure in brackets?

[vanderson009]

Hi James,

Thanks for your quick resonse.

My first column is TouchPoint, Second column is Monthname. i have four Months which are common

for each touch point and in bracket there is sum(Response) per Month.

Hope you understand.

-- Thanks

Villyee

[ali_hijazi]

do you mean you want for billing show the sum of responseNo for min date available then for devices the next month and so on?

[MK_QSL]

How billing is 2109?

devices 1388 coming?

Can you explain your logic pls?

[vanderson009]

sum of response is related to MonthName field, Which is not related to TouchPoint.

But if we click over any one of the touch point then respective touchpoint response per month

will come.

Thanks Manish, Hope you understand my reuirement.