1 Reply Latest reply on Sep 15, 2016 2:48 PM by Stoyko Kostov

    field calculation

    brant wu

      Hi ALL :

      Is is possible to get a view as follow:

        • 1. Re: field calculation
          Stoyko Kostov

          Hi Brant,


          Here's one possibility that's less than elegant because everything is hard-coded and limits your ability to filter brands, change calculations, etc.


          Basically I calculated your 4 segments - Brand1, Total Brand1, Brand2, and Total Brand2 in 4 separate worksheets and combined them in a dashboard.


          To calculate the totals I used the following fields:

          TotalB1 - IIF([Brand]="B1",Sales,0)

          TotalB1Percent - IIF([Brand]="B1",Sales,0)/{FIXED[Store]:SUM([Sales])}

          Similarly for B2.


          As you see, everything is hard-coded, and it is hard to introduce filters. This can be somewhat alleviated by using parameters instead of hard-coding the brand names.


          Take a look at the attached and let me know if you have questions.