Power GETPIVOTDATA - based on multiple items in CELL reference

[Zaoka]

HI,

I am trying to create formula that will extract data from power pivot table based on cell reference.

Issue is that cell contains more then one Item, separated with " ; " , I can change this in any form, but I need to keep it in one cell
Example Account num.

A2 = 5110;51100

Is it possible to create getpivotdata formula that will basically sum accounts based on one cell content . So if I change cell content result change without changing formula

=IFERROR(GETPIVOTDATA("[Measures].[balance sum]";'Class 5'!$A$5;"[Report 1].[Account]";"[Report 1].[Account num.].&[5110]");0)

.

At this moment I sum multiple getpivotdata , but it is getting hard to maintain cell contents and formulas. So i wanted to cut out formula part

=IFERROR(GETPIVOTDATA("[Measures].[balance sum]";'Class 5'!$A$5;"[Report 1].[Account]";"[Report 1].[Account num.].&[5110]");0)+IFERROR(GETPIVOTDATA("[Measures].[balance sum]";'Class 5'!$A$5;"[Report 1].[Account]";"[Report 1].[Account num.].&[51100]");0)

.