Refer to another row of Pivot (or part of subtotal)

[#1]

  My idea is
simple – but already several weeks – cannot find how to do that!

Step by
step:

1. I have added another calculated value next to normal one in pivot table:

=sum({ $<initialReliableDatasource={yes}, shortdatasource= {'*'}>}(factvalue/rate2gpb)) :

=year(factperiod)	recontypename	initialReliableDatasource	shortdatasource	Market	Adriatic
2014	Consumption All Categories	yes	refdatasource	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories	yes	refdatasource	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	23
2014	Consumption All Categories		datasource1	Sum(factvalue/rate2gpb)	18
2014	Consumption All Categories		datasource1	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	0
2014	Consumption All Categories		datasource2	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories		datasource2	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	0

The idea – to have just 2 values – first
normal, another is same but system must not look at “shortdatasource” field
filter.

I want line:

  =sum({ $<initialReliableDatasource={yes}, shortdatasource= {'*'}>}(factvalue/rate2gpb))

  To show value regardless of shortdatasource
, and then  since value is expected as total sum of
(refdatasource+datasource1+datasource2), I want additionally apply
filter “initialReliabledatasource = yes”.

But since even regardless of shortdatasource
fails – I cant go further.

My expectation is to have numbers in value column
like :

=year(factperiod)	recontypename	initialReliableDatasource	shortdatasource	Market	Adriatic
2014	Consumption All Categories	yes	refdatasource	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories	yes	refdatasource	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	23
2014	Consumption All Categories		datasource1	Sum(factvalue/rate2gpb)	18
2014	Consumption All Categories		datasource1	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	23
2014	Consumption All Categories		datasource2	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories		datasource2	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	23

But indeed I have this – see zeroes at every
expression excep of "golden record - reliable datasource = yes":

=year(factperiod)	recontypename	initialReliableDatasource	shortdatasource	Market	Adriatic
2014	Consumption All Categories	yes	refdatasource	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories	yes	refdatasource	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	23
2014	Consumption All Categories		datasource1	Sum(factvalue/rate2gpb)	18
2014	Consumption All Categories		datasource1	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	0
2014	Consumption All Categories		datasource2	Sum(factvalue/rate2gpb)	23
2014	Consumption All Categories		datasource2	=sum({   $<initialReliableDatasource={yes}, shortdatasource=   {'*'}>}(factvalue/rate2gpb))	0

Can you
advice why my expression doesn’t work?