matrix visual - need to add and subtract between the matrix visual columns

[Anonymous]

I am trying to add 2 new columns in the matrix visual: to add 2 columns and subtract one column within the visual. 

I do not want to create a column in the query editor as the dataset is huge and I did a direct query to fetch data. Please explain if anyone knows. Thank you. 🙂 

I am trying to add Entry, Tag-on and subtract Undo for one column and similarly add exit and tag-off for the other new column.  @needhelp 

Facility	Entry	Exit	Undo	Tag-on	Tag-off
chennai	123	234	12	222	334
mumbai	123	234	12	345	432
delhi	134	234	12	212	122
kolkata	564	234	11	122	111

[Anonymous]

Not entirely sure what you're looking for, a little clearer explanation would help. 

Column 1 = 
SUMX(Table, Table[Tag-on] + Table[Entry] - Table[Undo])

Column 2 = 
SUMX(Table, Table[Exit] + Table[Tag-off])

[Anonymous]

The columns in this matrix visual table are not actual columns in the datasets. So, I get the error: Cannot find table, cannot find name.

I'm unable to create measures as well with the matrix visual column headers (Entry,exit,undo)

[Anonymous]

@Anonymous Can you show what the data looks like? You could reference the Measures instead of tables to get the effect you're looking for.

[Anonymous]

@Anonymous Thanks for the reply. The data looks like this:

In the matrix visual the ride_type is used as the column header and rows are taken from the facility. The values that needed to be added and subtracted are the count of txn_id. 

Hope this makes sense. Thanks for your time 🙂