Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I am trying to achieve the pivot tablet to be calucalted properly but I could not
kindly help me out in exact solution.
You need further if-conditions in your expressions - with only one expressions you couldn't use references to other columns. Here simplified without your condition on south pacific:
=IF(Match(ServiceOLR.Type,'Budget','Actuals'), NUM(SUM(ServiceOLR.Amount), '#,##0'), IF(Match(ServiceOLR.Type,'Calc'),
NUM(
SUM({1< ServiceOLR.Type = {'Actuals'} >}
total <ServiceOLR.Sub_Region, ServiceOLR.Country, ServiceOLR.PL> ServiceOLR.Amount) /
SUM({1< ServiceOLR.Type = {'Budget'} >}
total <ServiceOLR.Sub_Region, ServiceOLR.Country, ServiceOLR.PL> ServiceOLR.Amount), '#,##0%')))
- Marcus
Try this: column(4) / column(1)
- Marcus
Hi
I used but not giving desired result
can you brief me a bit more how to and where to use it
You need further if-conditions in your expressions - with only one expressions you couldn't use references to other columns. Here simplified without your condition on south pacific:
=IF(Match(ServiceOLR.Type,'Budget','Actuals'), NUM(SUM(ServiceOLR.Amount), '#,##0'), IF(Match(ServiceOLR.Type,'Calc'),
NUM(
SUM({1< ServiceOLR.Type = {'Actuals'} >}
total <ServiceOLR.Sub_Region, ServiceOLR.Country, ServiceOLR.PL> ServiceOLR.Amount) /
SUM({1< ServiceOLR.Type = {'Budget'} >}
total <ServiceOLR.Sub_Region, ServiceOLR.Country, ServiceOLR.PL> ServiceOLR.Amount), '#,##0%')))
- Marcus
you use column(#) for expressions if you have few/severals, instead of column(#) you can use [label_name]
but not in your case as you have only one expression - so one column
you need to do calculation inside expression
I sent you my example, let me know
Thanks Marcus for guiding me though
Marcus Soomer,
Thanks for providing me the solution.
here i need some more help from you
how to remove extra spaces after that "country dimension" in the webview.
Do suggest me
A column-width of 0 isn't possible within the gui but minimizing could be done without enabling compact view and the you could it disable again:
- Marcus
Hi Marcus
Thanks for responding me
i am not getting the exact solution what i was trying for spaces are still existing after the country dimension