Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
GerardVall's avatar
GerardVall
Frequent Visitor
2 years ago

Hello, I'm dealing with a similar isue.

 

I have a Measurement that includes a LookUpValue to change a percentage value on the measurement depending on a date. 

 

This part of the formula has to be excluded in the total row but i haven't been able to get it work.

 

To understand what i'm trying to do:

I need a measurement to calculate the objective of sales on my company. The objective is 20% higher of the total of sales in the last year but its distributed diferently by months.

  1. January: 8% of that 20%
  2. February: 9% of that 20%
  3. March: 6% of that 20%
  4. etc....

 

If someone could help i would apreciate it so much.

 

 

Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Share some data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

    • GerardVall's avatar
      GerardVall
      Frequent Visitor
      2 years ago

      Hi,

       

      Here is the example with data:

      2023 Sales:12000000
      2024 Objective:14400000

       

      Month% of 20%Sales per month 2023Desired ValuesFormula
      January0,07100000011680002023Sales*0.2*0.07+SalesMonth
      February0,08100000011920002023Sales*0.2*0.08+SalesMonth
      March0,08100000011920002023Sales*0.2*0.08+SalesMonth
      April0,08100000011920002023Sales*0.2*0.08+SalesMonth
      May0,09100000012160002023Sales*0.2*0.09+SalesMonth
      June0,09100000012160002023Sales*0.2*0.09+SalesMonth
      July0,09100000012160002023Sales*0.2*0.09+SalesMonth
      August0,06100000011440002023Sales*0.2*0.06+SalesMonth
      September0,09100000012160002023Sales*0.2*0.09+SalesMonth
      October0,09100000012160002023Sales*0.2*0.09+SalesMonth
      November0,09100000012160002023Sales*0.2*0.09+SalesMonth
      December0,09100000012160002023Sales*0.2*0.09+SalesMonth
      TOTAL  144000002023Sales*0.2+2023Sales

       

      Sales are calculated with a SUM in another table.

       

      Thanks,

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        2 years ago

        I do not understand your question.  Someone who does will help.