Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

In the sample super store,how to get customers buying only furniture and not office supplies or technology [closed]

General Tech Technology & Software

Max. 2000 characters
Tuteehub
Replies

usr_profile.png

User

( 3 months ago )

In tableau for its sample super store dataset,I need to get the exclusive customers who buy only furniture and not office supplies and technology.

Want to display the exclusive customer names and their sales.

usr_profile.png

User

( 3 months ago )

You can put Customer on the Filter shelf and on the condition tab, use the following formula min([Category] = "Furniture") For boolean expressions, True > False, so MIN(condition) is true if and only if condition is true for every record. MIN() for booleans can thus be read as "every()" and MAX() can be read as "any()"

If you work with this group of customers a lot, you might want to define a set of Customers that only buy furniture, instead of a filter. There are lots of ways to think of sets, but one is just as a saved named filter.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif