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

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.