Two pivot table into one pivot chart

[mrowkowsky]

Hello,

It's my first post so if you have any comments regards form of post, feel free!

Problem:

I would like to have on one pivot chart fields which are able to filter (based on slicer) and fixed fields (sth like target line which doesn't change no matter what you choose from slicer).

When I create one pivot table it looks like this:

And the problem is that "Min of CENA" repeats everywhere and on the graph you can see a few identical lines:

So I thought that solution might be to create two pivot tables and combine them in one pivot chart:

And I create graph from the first pivot table:

Conclusion:

I would like to have one graph where I could have slicers with:
"ROK HEDGE" (year)
"DOSTAWCA" (supplier)
and fixed line with:
"Cena ropy w PLN/m3" (price of oil)

Do you have any ideas how to solve this problem?

Hopefully you will understand my issue.

Cheers,
Mateusz

 

[hartsie]

I think I am having trouble following. It would be easier if you could share a file that simplifies your example.