Author Topic: Format the Measure for Negative Weighted Alternate hierarchy ?  (Read 388 times)

Offline donap

  • Senior Member
  • ****
  • Join Date: Oct 2017
  • Posts: 53
  • Forum Citizenship: +0/-0
Hi all.
 I have the following Scenario of a dimension with an alternate with a negative weighted subsequent "c" level -
 The "Alpha Accounts"  total is correctly subtracted from "Num Accounts" to get the correct value for "Num vs Alpha Accounts"
The issue is -- the users want to see  the "Alpha Accounts"  total  as a Negative number..They don't necessarily know exactly which is a neg weight or not, and in Excel-Cafe , if they want to add a calculation,  they want to make sure if they "add" the value reflects negatively.
Is there a way to do this  ?
Thanks
 


All Accounts   6,348,162,498    
            123         1,235,097    
            456   2,347,980,184    
            789        88,928,401    
             abc    3,819,123,804    
             def        90,895,012    
             
Num vs Alpha Accounts   (1,471,875,134)    (alternate )
    Num Accounts             2,438,143,682     (alternate )
                   123                   1,235,097    
                   456            2,347,980,184    
                   789                  88,928,401    
     Alpha Accounts             3,910,018,816    (alternate - Neg Weight) *****
                    abc              3,819,123,804    
                    def                  90,895,012    


Offline AJAYC

  • Senior Member
  • ****
  • Join Date: Apr 2012
  • Posts: 63
  • Forum Citizenship: +2/-0
Hi Donap

Apologies in advance if I have not quite understood your post, but does the below work for you:

All Accounts   6,348,162,498
       123              1,235,097 ( 1)
       456        2,347,980,184 ( 1)
       789             88,928,401 ( 1)
       abc         3,819,123,804 ( 1)
       def              90,895,012 ( 1)



Num vs Alpha Accounts    (1,471,875,134)
 Num Accounts                 2,438,143,682  ( 1)
 Alpha Accounts              (3,910,018,816) ( 1)


 Num Accounts             2,438,143,682
       123                            1,235,097 ( 1)
       456                     2,347,980,184 ( 1)
       789                          88,928,401 ( 1)

 Alpha Accounts          (3,910,018,816)
       abc                      3,819,123,804 (-1)
       def                           90,895,012 (-1)


HTH
Ajay


Offline donap

  • Senior Member
  • ****
  • Join Date: Oct 2017
  • Posts: 53
  • Forum Citizenship: +0/-0
Thanks I will try that and see what feedback I get from the users !

 


       
Twittear