Categories
Filter Common Value Across Multiple Years
Answers
-
Aggregation will not work within filter, that's the simple rule. Try converting that as well to case statement.
CASE WHEN count(distinct case when "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2023' or "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2024' THEN "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" END by "Procurement - Direct Material Spend"."Voucher Invoice Details"."Part Number" ) >= 2 THEN "Actual Spend Amount" ELSE 0 END
0 -
I tried the said calculation however the result is 0 which should not be.
0 -
Please share the entire report XML. I can give a try.
0 -
This is easy if you do in pivot table, two columns represent date from two different years. The last one is a calculated column.
Just click on advanced tab and copy everything from XMLAnalysis window in a text file and share here.
0 -
Hi, @Bharat Agrawal have you check on it? Looking forward to positive response. Thank you! I appreciate your help.
0 -
Sorry bit busy with day job, will look into it later this week or weekend. would you find sharing your linkedin profile here, so I can pm you my contact details.
0 -
No problem. Here's my linkedin profile. Thanks Bharat!
https://www.linkedin.com/in/joven-de-luna-204132a5/
0 -
Great, will ping you
0
