0

What is the alternative for sumif (Excel formala) in AWS' QuickSight?

I need a column, that will horizontally scan the first column and show sum for the identical categories.

Please see example:

enter image description here

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
Oksi
  • 101
  • 3
  • Are you looking for a table that is literally like the "What I need" example, or is that example's purpose only to illustrate the calculation? If it is only to illustrate the calculation, can you provide some kind of mockup of what you hope to visualize in QuickSight? – sfuqua Nov 06 '18 at 20:17

1 Answers1

2

Use the function SumOver(). like SumOver(sum({Sales}),[{Category}])

JD D
  • 7,398
  • 2
  • 34
  • 53
Jayabharath
  • 21
  • 2