Forum Discussion

BenP1's avatar
BenP1
Frequent Visitor
8 years ago

Inbound and Total Revenue

Hi, would you help me with creating two new measures, one for Inbound Revenue and one for Total Revenue please.

 

 

All my data is in one table and the relevant existing fields are:

FYTD (Financial Year To Date values)

Delivery Area (Country e.g. UK, US, CH, JP)

HQ Area (Country e.g. UK, US, CH, JP)

 

Area Revenue (Revenue generated in area regardless of HQ Area)

Area Revenue 
Delivery AreaFYTD
UK100
US200
CH300
JP400

 

Inbound Revenue would be all revenue generated outside of Delivery Area where HQ is in Area

E.g.

Delivery AreaHQ AreaFYTD
USUK10
CHUK15
JPUK20
Total 45

 

I would like to use the "Inbound Revenue" measure to see "Total Revenue" in a Matrix e.g.

Area (New Column?)FYTDInbound RevenueTotal
UK10045145
US20055255
CH30065365
JP40075475

 

How would I create the Area (New Column?)? 

 

I also need Total Revenue as a new measure so I can create Year on Year (YoY) growth %'s

e.g. Total Revenue FYTD - Total Revenue PFYTD/ Total Revenue PFYTD

I have PFYTD (Previous Financial Year to Date) measure so need the Total Revenue measure to create the Total Revene  FYTD and Total Revenue PFYTD

I know how to create the (YoY) growth % once I have the "Total Revenue" measures.

 

Thanks in advance for your help.

1 Reply

  • Hi,

     

    Your question is not clear.  How were you able to derive the numbers in the Inboud revenue column of Table 3 from Table 1 and Table 2?

    Please clarify.