2 Replies Latest reply on Jul 29, 2018 2:58 AM by Jeevan Krishna

# how to add numbers and percent for multiple measures?

I have some measures, for which I want to display numbers and percents of total row .

currrently I can get to work either percent or numbers in the sheet.

I have this working in tableau

but I want to display like this.

 Field No PubCount No PubPercent Send PubCount Send PubPercent Grand Total Count of Do Not Send Publication 21895 17% 107280 83% 129175 Distinct count of m NumPerLivUnit 2 0 12% 0 88% 0 M 0 5 Member 3540 25947 29487 M 11 15 Member 2474 17% 12059 83% 14533 M 16 20 Member 2438 18% 11052 82% 13490 M 1Plus Engage 3614 16% 19203 84% 22817 M 21 25 Member 2925 22% 10316 78% 13241 M 26 30 Member 1708 21% 6339 79% 8047 M 2Plus Engage 452 14% 2815 86% 3267 M 31 35 Member 1061 20% 4323 80% 5384 M 36 40 Member 587 18% 2648 82% 3235 M 3Plus Engage 49 13% 330 87% 379 M 41 45 Member 462 21% 1746 79% 2208 M 46 50 Member 224 21% 853 79% 1077

I am new to this community please let me know what options I have to display data both in numbers and percent.

• ###### 1. Re: how to add numbers and percent for multiple measures?

Rashmi,

You can just add same measure twice. One with table calculation for percent(which you already have) and other is just count.

Let me know if I am missing anything.

Thanks,

Ankit Bansal

• ###### 2. Re: how to add numbers and percent for multiple measures?

HI Rashmi,

What Ankit mentioned is right.But one thing you need to remember is you cannot add the same measure twice.

But, once you have added a measure and changed it to a table calculation, it is considered to be an entirely separate entity which allows you to drag and drop required measures into the measure values shelf which will show just numbers.

Hope this helps