shiningstar
New Member
- Joined
- Sep 26, 2014
- Messages
- 7
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?
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?