Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a data set :
Can make a pivot table likes below? I'm no idea how to do Opening & Closing Balance.
Thanks for any help.
Could you provide us with the data in excel?
Thank you
Thank you first. Please find the attached Excel file.
tmp: Directory; LOAD fselldate, freddate, fexpdate, FREDITEM1, foutlet1, fcoupon, fstatus, Year(Date#(fselldate, 'YYYYMMDD')) as Year_sell, Year(Date#(fexpdate, 'YYYYMMDD')) as Year_exp, 1 as Issued, if(Len(Trim(freddate)) = 0, 0, 1) as Redamption FROM [..\Downloads\data.xlsx] (ooxml, embedded labels, table is Sheet1);
I got a little further but I couldn't manage to understand the login behind Opening and Expire expressions.
Could you collaborate on the algorithm?