Qlik Sense - Igonore selective dimensions

[Qlikuser225]

Hi All,

Can anyone please help me solving below issue.

Load * inline [

Name, Center, Score

AAA, Berlin, 90

BBB, Berlin, 98

CCC, Mexico, 97

DDD, Mexico, 94

EEE, USA, 98

FFF, Argentina , 90 ];

I want to show in a  table box with dimensions Name and Center and Expression as Score of individual Name and Total Score for their respective location/

like for example -  when i select AAA, i need to show AAA score as 90 in one column and ONLY Berlin total Score as 188 (90+98) in another column a table box.

Can anyone please help me with this issue.

Thanks alot

[MatheusC]

Hello,  @Qlikuser225 

To Ignore the section and continue bringing the total value, you can use the wildcard character * in your expression, for example:

Dimension={"*"}

[MarcoWedel · Accepted solution]

maybe one solution could be:

Sum({$<Name=,Center=p(Center)>} TOTAL Score)

hope this helps
Marco