Sandeep Narayanaswamy Posted April 5, 2019 Share Posted April 5, 2019 Hi All, I'm new to the spotfire and need help with the below issue. I have 5 columns named Country, Category, Channel, Meausre and 2016(Real). Below is the example dataset. Country Category Channel Meausre 2016 India OC Hyper Unit 10 India PC Hyper Value 20 India OC Super unit 10 USA PC Super Unit 20 USA PC Hyper Unit 40 China OC Super Value 50 China PC Hyper Value 50 China OC Hyper Value 30 China PC Super Value 20 Below isthe data table in Spotfire I'm creating. I have Category, Channel and Measure in filters. Based on the filter selection values in 2016 column should be summed up. Thanks in advance for your help. Regards, Sandeep Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 8, 2019 Share Posted April 8, 2019 You can use cross table with country in Vertical Axis, column names in Y-Axis and sum(2016) as [2016FY] in Cell values. So whenever you apply filter, related data will appear in visualization and data will be grouped by country. Finally you will get sum of 2016 Link to comment Share on other sites More sharing options...
Sandeep Narayanaswamy Posted April 10, 2019 Author Share Posted April 10, 2019 Thanks a lot, it worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now