I have a table that looks like this:
I want to make charts with the sales for our company without selecting it first.
thought about an if statement something like if([Company]=[Our Company],Sales but i am kinda stuck there.
Thanks for the Help in advance
Solved! Go to Solution.
Can you share the sample file
I created a chart with Customer Dimension showing sales only for 'Our Company', please check for your reference.
It shows data only for our company in the chart
Thank you for your help,
and sorry for replying so late, i can confirm that this works in the demo file you sent. I changed my datastructure to work around my issues.