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

Adding calculated Rows to data table


ringojb

Recommended Posts

Hello,  I am trying to add rows to an existing table...or need to add a custom expression to a cross table.  I'm not sure which is easier?  Simply put i have 3 meters that have readings on each day.  I need to add a 4th row each day that calculates readings based on the existing readings.

  date meter volume  
  1/1/2024 a 20  
  1/1/2024 b 10  
  1/1/2024 c 30  
add row 1/1/2024 calc 0.5 A/(B+C)
  1/2/2024 a 15  
  1/2/2024 b 5  
  1/2/2024 c 30  
add row 1/2/2024 calc 0.428571429

 


How/where would i put this formula  A/(B+C) to generate additional rows or expressions?

 

Thank you

Edited by ringojb
Link to comment
Share on other sites

Hi,

 

You can add a custom expression in cross table as below.

1. Create Pivot as below in data table transformations. Columns2 here is Date column.

image.png.c99b924e133ca1e6b94b4c931ac13bcb.png

2. Then create a cross table with cell values custom expression as below.

image.thumb.png.1ff3fd66e49f3d0f015f4f7d8a18ef74.png

 

Thanks,

Viji

  • Like 1
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...