Jump to content
We've recently updated our Privacy Statement, available here. ×

How to sum the value based on multiple filter options in Spotfire table


Sandeep Narayanaswamy

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...