how to create calculated column which contains grouped data?

[shiningstar]

I have a SQL table like A( Customer, revenue,Industry )
Customer Industry Revenue
Microsoft Tech 100M
Adobe Tech 200M
VW Automotive 100M
HP Gas Oil and Gas 50M

I am using "Industry" as a slicer here. But I want one more field "cluser_Industry" as a slicer.
where Cluser Industry shows if Tech & Automative then " General"
if Oil&gas then "Energy&resources".


How can I create this calculated column and use it as a slicer?

 

[ImkeF]

Not really sure, but thinking that you will obtain your desired result in a different way:

Create the following table “Group”:

Industry-CluserIndustry
Tech- General
Industry-General
Oil&Gas-Energy&resources

Connect to TableA on Industry and use "CluserIndustry" as a slicer

 

[shiningstar]

That answered my question asssuming I need to build a data model between tableA and Group with matching key as " Industry" .Am I right?

 

[ImkeF]

Yep