Hi all,
Sorry I did submit this to a wrong post.
Here I come.
I have been trying to work out this formula to auto populate per customer's status with a few steps, by implementing multiple excel functions e.g: replace, cell, aggregate, index:
B1 Formula = REPLACE(CELL("filename";A1);1;SEARCH("]";CELL("filename";A1));"")
B2 Formula = COUNTIFS(Revenues[Customer];B1)
A5 Formula = IF(ROWS(A$5:A5)>$B$2;"";INDEX(Revenues[Reference];AGGREGATE(15;6;(ROW(Revenues[Order type])-ROW(Revenues[Order type]))/(Revenues[[Customer]:[Customer]]=$B$1);ROWS(A$5:A5))))
File is saved in following link:
https://1drv.ms/x/s!Aqt4VfikFsyKdiapMYRPHtlSo5I
With this formula I was able to update all the rows of entries of Alianz DEW, but it doesn't work when I drill through and update the other customers, please take a look and give me a helping hand.
would be much appreciated !!
Thanks.
Sorry I did submit this to a wrong post.
Here I come.
I have been trying to work out this formula to auto populate per customer's status with a few steps, by implementing multiple excel functions e.g: replace, cell, aggregate, index:
B1 Formula = REPLACE(CELL("filename";A1);1;SEARCH("]";CELL("filename";A1));"")
B2 Formula = COUNTIFS(Revenues[Customer];B1)
A5 Formula = IF(ROWS(A$5:A5)>$B$2;"";INDEX(Revenues[Reference];AGGREGATE(15;6;(ROW(Revenues[Order type])-ROW(Revenues[Order type]))/(Revenues[[Customer]:[Customer]]=$B$1);ROWS(A$5:A5))))
File is saved in following link:
https://1drv.ms/x/s!Aqt4VfikFsyKdiapMYRPHtlSo5I
With this formula I was able to update all the rows of entries of Alianz DEW, but it doesn't work when I drill through and update the other customers, please take a look and give me a helping hand.
would be much appreciated !!
Thanks.
