Discussion Board for collaboration related to Creating Analytics for QlikView.
how can i subtract country sales for total linesalesamount and i should only see remaining balance in straight table.
Ex: total linesalesamount is $13,321,238.07 and austria sales amount $408404.49,
here can i see remaining balance in straight table.
i'm trying .
plz help me out
Thanks in Advance.....
Try like this
Sum ( Sales )
Sum( Total Sales )
Elaborate more on the requirement.
Try like below,
Sum(Sales) - Sum(Total Sales)