Luke Dyer's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Videndum Production Solutions

Country

Latest Posts

Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar I created a unique field for the lowest level made up of Site, Brand, Part and Transaction Type to use in your newest calculation and this fixed the calculation for all levels.
- Luke_Dyer
- 9 days ago
- 1
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar This seem to help show all parts numbers in the grid however it isn't showing the correct values, I believe this is due to the fact we have another level below part number which is transaction…
- Luke_Dyer
- 10 days ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar This would work, as in show the correct values for each level and is quicker, however the client wanted the hierarchy functionality to only show the level the care to view.
- Luke_Dyer
- 10 days ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar Would you be able to elaborate more on this method, your initial method worked ok on a hand full of parts however for the whole data set it was crashing pyramid.…
- Luke_Dyer
- 10 days ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar Unfortunately its not and I did try this method initially but it did not work.
- Luke_Dyer
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@imbar Many thanks for replying and explaining this has worked!
- Luke_Dyer
- 3 wk ago
- Questions & Answers
- Reported - view
Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula

I have a report example that shows values accumulating over a two-year time frame. If, at any point, the value for a specific Part/Type falls below a defined threshold,…
- Luke_Dyer
- 3 wk ago
- 12replies
- 98
- Questions & Answers
- Answered
- Answered
Re: How to add subtotals for % Values to sum up to 100% in the category
Very useful function!
- Luke_Dyer
- 1 yr ago
- Discover
- Reported - view

Back to top

Home

View all topics