Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello friend, my start table is:
DATE ID Item Income/Expenditure Amount
15.12. T1015 Income 10
18.12. T1015 Expen -10
20.12. T1015 Expen 5
15.2 . T1017 Income 10
17.2. T1017 Expen 10
20.11. T1018 Income 50
21.11. T1018 Expen 50
15.10. T1019 Income 100
18.10. T1019 Expen -100
20.11. T1019 Expen 80
15.2 . T1020 Income 10
17.2. T1020 Expen 10
20.11. T1025 Income 50
15.10. T1028 Income 200
18.10. T1028 Expen -200
And result which I need is to show minus amount, but I need to show also others rows for given Item. The result table, which I need should be:
DATE ID Item Income/Expenditure Amount
15.12. T1015 Income 10
18.12. T1015 Expen -10
20.12. T1015 Expen 5
15.10. T1019 Income 100
18.10. T1019 Expen -100
20.11. T1019 Expen 80
15.10. T1028 Income 200
18.10. T1028 Expen -200
Can you help me, how can I do it ??
Thnak you
Check the attached
May be this:
Dimensions
DATE
ID Item
Income/Expenditure
Expression
Sum({<[ID Item] = p({<Amount = {'<0'}>}[ID Item])>}Amount)
Check the attached
It is OK. Thanks a lot my friend