Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Cross table - Dividing a value by the total of another column


Evelyn Pacio

Recommended Posts

I'm trying to get the % impact of a cell value over the total value of another column

All i am able to do using the over function is get the impact of apple reject qty over the total number of rejects, not volume.

thanks in advance for the help!

 

Here's the cross table:

for example, for the % impact on volume of apple, the formula would be 30386 / 7910088.

 

 

 

REJECT NAME

REJECT QTY

MOVE IN QTY

% IMPACT ON VOLUME

 

 

Apple

30386

2237121

 

 

 

Banana

27238

2738947

 

 

 

Coconut

20744

62511

 

 

 

Dates

15803

1877050

 

 

 

Eggplant

13502

994459

 

 

 

total

 

107673

 

7910088

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...