Changing view without selecting first.

[Jwillmann]

Hello Community,

I have a table that looks like this:

customer	company	sales
customer1	Our Company	2000
customer2	Our Company	3000
customer1	Company2	4000
customer2	Company2	5000
customer1	Company3	6000
customer2	Company3	7000

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

Jwillmann

[anushree1 · Accepted solution]

Try:

sum({<company={'Our Company'}>}Sales)

[Jwillmann]

Thank you for your help Anushree1,

sadly that does not work, my barchart is still showing the sales for all 3 companies.

[anushree1]

It should work what is the dimension you are using

[Jwillmann]

The Dimension is Month,

sorry should have added that i have more fields then the mentioned.

Thought they are the important ones.

[anushree1]

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

[Jwillmann]

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.

[anushree1]

No worries at all..

Glad that its working:)