Forum Discussion
Group on just one level
Hi Anonymous,
Is the excepted result you need?
Regards,
Frank
Sorry no, I don't want the old and new value summed/counted I just want them exactly as they appear in the data, but without the repeating username (it is just a layout thing)
so using my example
USERA
GDTotalCostAmountMST 22/01/2019 14:48 520 0
GDTotalCostAmountMST;22/01/2019 14:44;81550;0
GDTotalCostAmountMST;22/01/2019 14:43;12250;0
GDTotalCostAmountMST;22/01/2019 14:43;804.48;0
GDTotalCostAmountMST;22/01/2019 14:42;43334.8;0
GDTotalCostAmountMST;22/01/2019 14:34;-43334.8;0
GDTotalCostAmountMST;22/01/2019 14:32;1600;0
GDTotalCostAmountMST;22/01/2019 14:32;280;0
GDTotalCostAmountMST;22/01/2019 14:32;39000;0
GDTotalCostAmountMST;22/01/2019 14:33;41.72;0
GDTotalCostAmountMST;22/01/2019 14:33;11000;0
GDTotalCostAmountMST;22/01/2019 14:33;2200;0
USERB
GDTotalCostAmountMST;22/01/2019 9:24;0;623
GDTotalCostAmountMST;22/01/2019 9:24;623;0
GDTotalCostAmountMST;22/01/2019 9:32;0;143.76
GDTotalCostAmountMST;22/01/2019 9:32;143.76;0
GDTotalCostAmountMST;22/01/2019 10:36;0;572.76
GDTotalCostAmountMST;22/01/2019 10:36;572.76;0
- Anonymous7 years agoNot applicable
In SSRS I would just do