how to totals data for rows

Swathi — Fri, 15 Nov 2024 20:58:22 GMT

i have different types and countries are there , i need totals for each type and countries, some places need total few rows like that

in the above screenshot we can see i have group, country, type fields are there, for group is Europe, i need all totals Europe group. as group europe i have 3 types Totals are there one is

1.TOTAL

2.TOTAL Power

3.TOTAL Gas

TOTAL means summ of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), irrespetive of which type it is. it will summ of all rows for Group='Europe'

TOTAL Power means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), where Group='Europe' and Type ='Power'

in the above screenshot we can see i have group, country, type fields are there, for group is Europe, i need all totals Europe group. as group europe i have 3 types Totals are there in country field only is

1.TOTAL

2.TOTAL Power

3.TOTAL Gas

TOTAL means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), irrespetive of which type it is. it will sum of all rows for Group='Europe'

TOTAL Power means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), where Group='Europe' and Type ='Natgas'.

i tried below formula, but iam not any getting any data it is 0.0 as seen screenshot.

Pick(SrNo,

if(GetFieldSelections (Group)='Europe',
if(Country= 'TOTAL',
{<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF),
if(Country='TOTAL Power',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Power'}>} $(vPortfolioValue_mCHF),
if(Country='TOTAL Gas',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Natgas'}>} $(vPortfolioValue_mCHF)

)
)

)

),{<Year={$(vYearSelect)},Group={'Europe'}>} $(vPortfolioValue_mCHF))

Kindly help to get these it's very urgent and important.

@BrunPierre , Please help me.

topic how to totals data for rows in App Development

how to totals data for rows