My idea is
simple – but already several weeks – cannot find how to do that!
Step by
step:
- 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?
