Pie Chart Based on Columns

[#1]

I have a source data like this:

RUN_ID	CLIENT	BRR_SerialNo	BRR_Status	BRR_RetireDate	BRR_City
2	MY	2	1	0	1
2	MY2	1	2	1	0

And I want a Pie Chart like this when I click the Client MY:

The problem is that I want to base myself on columns instead of rows. Should I make a table transformation first? If yes, how?

Thanks,

Miguel

[#2]

I think I'm on the way.

What I did was enabling the transformation step when building the script and transposed the table.

[#3]

I'm not sure if I really have to rotate the table.

Because I can have infinite clients, and then I need to have a listbox to select the client and auto update the pie chart.

So I don't know how to do this with rotating the table because I can have a non determined number of columns...

[#4]

Any idea? Maybe if I change the source file first using some developer skills?

[#5 · Accepted solution]

Done it!!!!!

PrePie:

Load @3 as Client,

  @7 AS BRR_SerialNo,

     @8 AS BRR_Status,

     @9 AS BRR_RetireDate,

     @10 AS BRR_City

FROM

[..\Data\foo.tabdel]

(txt, codepage is 1252, NO labels, delimiter is '\t', msq)

store PrePie into ..\QVD\~PrePie.qvd;

Pie:

CrossTable(Reason, Percentage)

LOAD Client,

     BRR_SerialNo,

     BRR_Status,

     BRR_RetireDate,

     BRR_City

FROM

[..\QVD\~PrePie.qvd]

(qvd);