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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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