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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JASalinas
Creator
Creator

Divide Column / Sum from Table or Pivot Table

Hi My Friends

I have a Table or Pivot Table from an Expression: Sum({<[Account] = {"611*", "612*", "616*"}>}[Amount])

Here Pivot Table

JASalinas_2-1587955010884.png

I want to divide the value of the column Amount / Sum({<[Account] = {"611*", "612*", "616*"}>}[Amount])  to show the percentage for Ex.

Column Amount 60160 / 2,281,884.48 (Sum({<[Account] = {"611*", "612*", "616*"}>}[Amount]) )=0.026 for each row.

Please Help me!...

Than you very much!.

Labels (2)
0 Replies