Limit data in column of a cross table

Hi Expert,

I have a data table like below.

Data Table

Name Subject Marks
A Math 50
A Physics 54
A Chemistry 65
A Statistics 85
B Math 45
B Physics 25
B Chemistry 35
B Statistics 75

And I want to set up a cross table like below:

Cross Table Visualization

Name Total Marks Math
A 254 50
B 180 45

How do I add a custom expression to add a column for Math only? I can not bring Math (which is a row from [Subject] column) in the custom expression

I know that I could do a transformation however looking at how the data is setup I can not do transformation as well as subset.

Really appreciate your help!!

Best,

Bunty

(2) Answers

Login