-
1. Re: nested LOD calculation of sum across category
Norbert MaijoorDec 24, 2018 8:03 AM (in response to Nellie Rajarova)
Hi Nellie,
Not sure but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.
M1. max Qty: if attr([Category id])!=2836481 then max({fixed [Category id],[Subcategory Id]:max([Qty])}) end
Hope it helps.
Regards,
Norbert
-
LOD nalmai_v10.5.twbx 65.6 KB
-
-
2. Re: nested LOD calculation of sum across category
Nellie Rajarova Dec 24, 2018 8:53 PM (in response to Norbert Maijoor)1 of 1 people found this helpful@Thanks Norbert. This works if I have Category Id in the shelf. I used the formula
IF attr([Category id])=2834316 or attr([Category id])=2836481
then
sum({fixed [Category id],[Subcategory Id]:max([Qty])} )
end
The moment I want the the sum of 52 + 34, this does not work. Let me know if you have a solution.@Nobert Maijoor
-
3. Re: nested LOD calculation of sum across category
Norbert MaijoorDec 25, 2018 2:28 AM (in response to Nellie Rajarova)
-
4. Re: nested LOD calculation of sum across category
megha gawali Dec 25, 2018 2:42 AM (in response to Nellie Rajarova) -
5. Re: nested LOD calculation of sum across category
Nellie Rajarova Dec 25, 2018 5:35 AM (in response to Nellie Rajarova)Thanks Norbert. Merry Christmas !
This solution worked
-
6. Re: nested LOD calculation of sum across category
Nellie Rajarova Dec 25, 2018 5:37 AM (in response to Norbert Maijoor)Thanks Norbert. Merry Christmas !
This solution worked
-
7. Re: nested LOD calculation of sum across category
Norbert MaijoorDec 25, 2018 6:11 AM (in response to Nellie Rajarova)
Hi Nellie,
You are welcome:) Please close the thread with a "helpful" or "Correct Answer" so the community is aware and can focus on other challenges.
Your cooperation is appreciated.
Have a nice evening.
Regards,
Norbert