Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have following table for employee salary , Now I have CTC act filed in transaction ie. in salary transaction ,
Now when I want to show ctc from 28/2/13 to 31/08/13 report should show me 620160 ctc act
after 31/08/13 report should show me 744240 as ctc act earn how to show this in pivot table.
CTC_ACT | NEMPID | D_PAY_DATE | |
620160 | 1210 | 28/02/2013 | |
620160 | 1210 | 31/03/2013 | |
620160 | 1210 | 30/04/2013 | |
620160 | 1210 | 31/05/2013 | |
620160 | 1210 | 30/06/2013 | |
620160 | 1210 | 31/07/2013 | |
620160 | 1210 | 31/08/2013 | |
744240 | 1210 | 30/09/2013 | |
744240 | 1210 | 31/10/2013 | |
744240 | 1210 | 30/11/2013 | |
744240 | 1210 | 31/12/2013 |
Thanks
Vikas M
Doubtful about your question... Could you try to load a sample file?
Create a pivot table, use D_PAY_DATE as dimension and only(CTC_ACT) as expression. See attached qvw.