Fixed graph with selection via masteritem

[KirstenKa]

 see attachment

In my graph I created a dimension to select for Men only in the graph

This is the formula

What I want is a fixed graph that shows data for “men” only and another fixed graph for “women” only like this

men                                                                    women

However when I drop the dimension in the graph, it only gives me an option to “replace” (replace SapFMS status or Season (SS24)) or to “assign a color” (not sure what this does but it doesn’t resolve what I want), but I do not want to replace, I want to keep SapFMS status and Season (SS24), and in the graph have a fixed selection for men

[Zapparoli · Accepted solution]

Hi @KirstenKa .

Instead of using a calculated dimension, you a set analysis on your measure like:

Sum( {<[SAP.Gender Des]={'Men'}>} YourField).

and on the other chart:

Sum( {<[SAP.Gender Des]={'Women'}>} YourField).

Let me know if it helps.

-Zapparoli

[KirstenKa]

Indeed will recall this solution from a long time. Will try it out when I start working on it again and will mark it as a solution when it works, thanks