How to create in a table relative % against totals

[#1]

Hi,

I'm trying to créate a table like the following one, showing an additional column with the % of the line agains the total. A relative figure. How can I build this column?

Thank you very much!

                      Sales           %

James               10            17%

John                  20            33%

Katherine          30             50%

Total                  60            100%         

[oknotsen]

For your second column, use an expression like this:

Sum(Sales) / Sum(TOTAL Sales)

[sunny_talwar]

Or you can use the relative option available on the expression tab of the straight table object

[oknotsen]

I see you liked the replies.

Question is: Did it also answer your question?

If so, could you please flag the Correct Answer and possible Helpful answer?

If not, please tell us with what part of this topic we can still help you .

[#5]

Thank you very much!

that gets a long way, however, i have the table divided by 2015 and 2016 and also i take out Ben.

The total is referring to both 2015 and 2016 and including Ben. I get:

                                2015                                   2016

                      Sales           %                  Sales            %

James               10            4%                    10           4%         

John                  20            8%                  20         8%

Katherine          30             12%                 30           12%

Total                  60            25%                 60           25%

(BEN has 50%. I filtered him in the Row ítem.)

While i would like to get:

                                2015                                   2016

                      Sales           %                  Sales            %

James               10            17%                    10           17%          

John                  20            33%                  20         33%

Katherine          30             50%                 30           50%

Total                  60            100%                 60           100%

(And Ben, sales have been taken out of the table.)

Thank you very much again!

[sunny_talwar]

Try this:

Sum(Sales) / Sum(TOTAL <Year> Sales)

[#7]

Thank you for your answer.

I still have to manage how can I take out Sam of all the figures?

[sunny_talwar]

Did this work?

[#9]

Yes! The year thing worked perfecty. Thank you. However, the Sam ítem i don't know how to remove it. Is it posible to apply a filter to all bata beign used in the table? As I said, i used the filter in the rows, but when I use the TOTAL Sam is still there!

Thank you one again,

Nico.

[swuehl]

Try

Sum({<NameField -= {'Ben'} >} Sales) / Sum({<NameField -= {'Ben'} >} TOTAL<Year> Sales)

as expression in your table chart with dimensions Year and NameField.