Skip to main content
Topics#Tableau Desktop & Web AuthoringAzel bl's Question
Azel bl (az) asked in #Tableau Desktop & Web Authoring
Apr 15, 2021, 11:48 PM

Table Calculation : Percent of total and sub-total

Hi All,

 

I'm trying to calculate two percent of total in the same column. The Column percent should show

 

  • For categorie : %= NB records / Total records (imobilier) for each Status of shipping column
  • For Sub-total : %= NB records / Total records for each Status of shipping column

 

There is two categories, but I'm interested only in the first one (Mobilier)

 

Example :

 

How can I merge different percentages in one column :

 

Table Calculation : Percent of total and sub-totalThank you for your help!

Supermarket.twbx
2 answers
  1. Vishwarath Nagaraju (Discovery Inc)
    Apr 16, 2021, 2:11 AM

    I might be wrong. Just trying to understand why can't you change your table calc compute using option to segment as shown in the below snapshot?

    I might be wrong. Just trying to understand why can't you change your table calc compute using option to segment as shown in the below snapshot?If not I might be missing something here and can you elaborate a little.

Write an answer...
0/9000