This content has been marked as final. Show 2 replies
I am struggling with an expression for my pivot table.
For example please have a look at pivot table:
I would like to write an expression which will show me the value of latest week in corresponding month.
Co for example for car ID 910, I would see 80 in Aug, 0 (or null) in Jul, and 91 in September.
Week column is for reference only and in final pivot it will be gone.
I am attaching sample qvw document for your reference.