Merging 2 Pivot Tables

[benjamin_schulz]

Hi all,

I have a problem that I can't solve myself.

I have 2 Pivot tables on my worksheet with the same dimension. I want to concatenate the Columns of the second table at the end of the first table. See pictures

this is the first table.

this is the second one. 

Now i want to merge these to tables in the way that the second table wont split these values into the clusters like the values in the first table.

anybody has an idea how this could work?

Have a nice day.

greets Benjamin

[anushree1]

why dont you add cluster above 80% and Cluster above 90 % expressions in the first table

[benjamin_schulz]

then this happens:

it gets split up in cluster 1,2,3 and so on but I just want the average for the whole row.

[Stevie_Go]

Hi Benjamin,

without knowing your data model I can only "guess" what you try to achive.

Are the cells in the first pivottable calculated or just loaded from a table?

If you supply more details maybe we can help. At least we need the information:

1. How does your base data look like

2. What do the pivottable cells calculate (the formula)

Br, Stevie

[benjamin_schulz]

Thanks for the help first.

What you're guessing is quite right. The data in the first table is just loaded from a table. The values in the second pivot table are calculated in the way you already described. It is counting how many entries (of the data the first table uses) are above 0.8/0.9 devides by the count of all entries.

My Base data has many attributes. One of them are the Clusters. To each cluster with a specific attribute combination there is an "accuracy" value. these values i display in the first table.