Limit data in column of a cross table

Hi Expert,

I have a data table like below.

Data TableName | 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 VisualizationName | 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

+ Add a Comment