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%         

[sunny_talwar · Accepted solution]

To remove, you can use set analysis. Stefan has provided one expression, you can use that or this:

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

His expression will still allow for selection in NameField, the above will always show all NameField except Ben even if you make selection in NameField.

[#3]

Thakn you very much! this worked perfectly!

Have all a nice weekend!

[#4]

Thank you very much!

[#5]

It worked!

Now i'm facing the following issue. Im trying to get out also a year out of the table. It is "date.autocalendar.year". How can I add an AND clausure here? I've tried a lot of options, the tool marks them as correct in terms of format but finally there is no effect.

Thanks again.

Nico.

[sunny_talwar]

May be this:

Sum({<NameField ={'*'}-{'Ben'}, date.autocalendar.year = {2016}>} Sales) / Sum({<NameField = {'*'}-{'Ben'}, date.autocalendar.year = {2016}>}TOTAL<Year> Sales)

[#7]

Thank you again, it worked.