Is there way like summary table use custom expression

[mike weng]

I want to do some calculationper column like summary table, but need to use custom expression,

for example, I have a table like below "Raw data table"and then want to get below "Result table".

Raw data table:

 

 

 

A

B

C

D

 

 

1

2

3

4

 

 

1

2

3

4

 

 

1

2

3

4

 

 

1

2

3

4

 

 

1

2

3

4

 

 

 

Result table:

 

 

 

Column name

Sum

Target

 

 

A

sum(A)

sum(A)*1.05

 

 

B

sum(B)

sum(B)*1.05

 

 

C

sum©

sum©*1.05

 

 

D

sum(D)

sum(D)*1.05

[Khushboo Rabadia]

It is not feasible to add custom expressions to summary table. You can create other columns and multiply A*1.05. Then add that column in summary table so sum will give you the expected result.

Other way would be tounpivot the data table so A,B,C,D columns will become rows and that can be easily fed to cross table. If you do not want to unpivot the data table,you will need to create custom expression for each column in cross table.

[mike weng]

Hi Khushboo,

 

First method is fine, but I think it's unsuitable if there are many columns.

 

Second method, I don't know how to unpivot data table, could you give me a example how to do this I'm many thanks for your help.

[Khushboo Rabadia]

Hello Mike,

 

Here are some references on how to unpivot the data:

 

https://docs.tibco.com/pub/sfire-analyst/10.6.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_unpivoting_data.htmrhhlterm=unpivot&rhsyns=%20

 

https://www.youtube.com/watchv=A9X5it_vabw

 

https://support.ruths.ai/support/solutions/articles/6000155785-how-to-unpivot-transformations

[mike weng]

Hi Khushboo,

 

It's really helpful, thanks.