need help in straight table

[musketeers]

Hi,

I need to create a straight table from following data:

Client	Prod-1	Prod-2	Prod-3	Prod-4
X1	100	200	300	400
X2	101	201	301	401
X3	102	202	302	402
X4	103	203	303	403
X5	104	204	304	404
X6	105	205	305	405
X7	106	206	306	406
X8	107	207	307	407
X9	108	208	308	408
X10	109	209	309	409

I have to create a list box for Client names so that user can select clients from that filter. This I have created.

Now in straight table I need to display following info:

Dimension	Expression
Total of 4 Products	<sum of all values of all 4 products of selected client>
Total of 3 Products	<sum of all values of all 3 products of selected client>
Total of 2 Products	<sum of all values of all 2 products of selected client>
Total of 1 Products	<sum of all values of all 1 products of selected client>

Since in my data table I have more than 4 products but I need to do this operation on only given 4 products.

I am trying to do but I am getting straight table in wrong format.

Please help me in doing this.

Thanks

[#2]

Hi,

Can you pls explain some more..

Little bit confusion...

As per your data i thought client - Dimension,

Sum([Prod-1])+Sum([Prod-2])+Sum([Prod-3])+Sum([Prod-4]) -- Expr

I hope check with this..

Sub2u

[#3]

Unless there is a reason to do the aggregation in the chart, I prefer to do it in the load script.

Attached is an example using the script and the horizontal feature of the straight table.

[iktrayanov]

Just use a pivot table and format it like this

[musketeers]

Hi,

Actually I have created cross table from my data table, where my fields in cross table are Client, Product, Value.

Now I was using if (match(Product, 'Prod-1'), 'Total of 1 Prod') type of expressions in dimension and SUM(Value) in expression.

But this is not working.

Actually I do not want to hardcode these things in Load script. So I am doing all these things in dashboard page only.

Is there any way as what I am doing in straight table is not giving correct output.

[iktrayanov]

Just use Product for your dimension and it should work.

[#7]

Ok, the customer is always right

If you want to do it in the expression, try this one,  it uses your data from the crosstable and then creates a chart that accumulates the first 4 values

[udit_kumar_sana]

Hi,

Pls find the attached file for your issue done at expression level.

Thanks & Regards,

Udit