I'm having difficulty in summing values in a column based on a value elsewhere. What I am trying is basically a SUMIF from Excel.
I want a new table that shows each unique Agent, with a sum column for Material Revenue when they are the Reporting Agent, and one column with the sum of Material Revenue when they are the ShipTo Agent. As QSense likes rows, when a Reporting Agent is not the ShipTo Agent, that revenue is not attributed to the ShipTo Agent under owning revenue.
Using the example under this, I am trying to make a table as follows (note that there are in actuality some 65 agents):
Agent | Owning | Delivering
X738 | SumIf X738 is ShipTo | SumIf X738 if Reporting