Hi Cummunity team,  I have a complex query to gather the data below, but a new request came up, it was asked to me to add in the report email subject the product category totals by Category. with the $result.productcat1$ and $result.productcat2$ I could apprach that, but the way I'm calculating the totals I'm not getting the expected numbers, because I'm appeding the columns from a subquery and transposing the values with  xyseries. Could you please suggest how can I sum(Sales Total) by productcat1 and productcat2 in a new field but keeping the same output as I have now?,  e.g.: something like if ProducCategory="productcat1"; then  productcat1=productcat1+SalesTotal, else productcat2=productcat2+SalesTotal ``` But Print the original output ```   Consider productcat1 and productcat2 are fixed values.  ENV ProducCategory ProductName SalesCondition SalesTotal productcat1 productcat2 prod productcat1 productR blabla 9 152 160 prod productcat1 productj blabla 8     prod productcat1 productc blabla 33     prod productcat2 productx blabla 77     prod productcat2 productpp blabla 89     prod productcat2 productRr blabla 11     prod productcat1 productRs blabla 6     prod productcat1 productRd blabla 43     prod productcat1 productRq blabla 55     Thanks in advance. ... View more