Total table

Question

Hello!&nbsp;I need to take the Total Line from numerous tables and put them in one table!&nbsp;&nbsp; Every green box is a table's total which derives from different filters in each table. The task is to create a table that looks like this:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column 2A1A2 + A3A2 + A3 + A1 + A&nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 788B1B2 + B1B3 + B2 + B + B&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 372C1C3 + C2C3 + C2 + C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 452D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 620-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;38&nbsp;&nbsp;Any ideas?&nbsp;Thanks!

v-yanjiang-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
Sorry I'm not very clear about where are the values in green box from. Could you please explain more about the expression "Every green box is a table's total which derives from different filters in each table."
&nbsp;
Best Regards,Community Support Team _ kalyj

anonymous · Answer

Every green box is a table visual. For example the A1A2 is the total counts of this table. I have renamed the "Total" with A1A2, A3, A1 etc. For instance, A1A2 - 126 means that the total counts (sum of the rows) on this table visual is 126. Each table (i.e. each green box) has different filters on it that is why I have different totals. Basically I need to extract the total of each table and then sum it. Please feel free to ask if it isn't still clear.

anonymous · Answer

Another approach that would lead to a possible solution is this:

I want to create a measure that count rows from a table

Measure1 = COUNTROWS(Table1)

and then filter it by three measures:

Measure2 < 0.04

Measure3 < 0.04

Measure4 >= 0.15

Any clues?

Forum Discussion

Total table

3 Replies

Related content

Wrong Total in Table

Cumulative Total

Table visual total

Table Column to Calculate Totals

Remove totals in matrix table