Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Hope_AA
Contributor III
Contributor III

Getting a financial % off Revenue within selection

I have a financial table with net total by Account Level and Year/Month. I want to be able to get the % of each Account Level from the 00_Revenue Level. so it would look like this : (i.e. for 2019-Jan, employee Costs would be -33,320,582/60,385,089 = -55.2%

  2019-Jan 2019-Feb
  ACTUAL ACTUAL
AccLevel Net Total % of Revenue Net Total % of Revenue
00_Revenue $60,385,089 100.0% $58,969,872 100.0%
01_Employee Costs (33,320,582) -55.2% (29,382,732) -49.8%
02_Prof_Fees (1,809,263) -3.0% (1,633,409) -2.8%
04_Depreciation & Amortization (5,134,904) -8.5% (5,096,265) -8.6%
06_IT_Related (1,206,262) -2.0% (1,329,522) -2.3%

 

Labels (4)
0 Replies