Values On Row Total

[tamilarasu]

Hi All,

   I have an excel file which filled with Region, Country and Target data. I need to show target value for region wise (from excel source) like below. I have used dimensionality() function but I could not achieve what I need. Instead of banging my head, I just posted here.

I have attached sample file. Any help would be much appreciated.

[tresesco]

Try:

If(Dimensionality()<=1, Avg({<RegionId={'>0'}>}Target),Sum({<RegionId={'>0'}>}Target))

[tamilarasu]

Hi Tresesco,

The above expression will show average for the specific region. But, my requirement is different. I need to show region wise target which is already defined (from the above attached excel file). We have Country target and region target separately.  Check the below screenshot

[Kushal_Chawda]

try this

If(Dimensionality()<=1, avg(Target),Sum(Target))

[tamilarasu]

Hi Kush,

As I already mentioned, I need to show defined region wise target (see excel file) and not average of the countries. Do you know any idea.!!

[tresesco · Accepted solution]

This?

If(Dimensionality()=0, Only({<Region={'Over all'}>}Target),

If(Dimensionality()=1, Aggr(Only({1-<RegionId={'*'}>}Target),Region),

Sum({<RegionId={'>0'}>}Target))

)

[tamilarasu]

Great and Thanks!!

[Kushal_Chawda]

great. tresesco the champ

[#9]

Try this expression,

=If(RowNo()= 0 , Sum(RegionTarget), Sum(Target))

[#10]

in presentation tab select show partial sum for Region, country, region id

and select subtotals on top