Luke Dyer's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Videndum Production Solutions

Country

Latest Posts

Re: How to Show Multiple Grand Totals without Repeating Measure Under Each Column
Your example help a lot. I forgot to say this was from a OLAP source, however your examples helped steer me in the right direction. using your example i created Three New Fields Prev Year MTD,…
- Luke_Dyer
- yesterday
- 1
- Questions & Answers
- Reported - view
How to Show Multiple Grand Totals without Repeating Measure Under Each Column

I want to show the current sales values per day for the current month with the grand total to the left. As show below. This is easy enough. However I want to add two extra (in yellow) grand total…
- Luke_Dyer
- 2 days ago
- 2replies
- 24
- Questions & Answers
- Answered
- Answered
Re: PYTD vs YTD Comparison , while Not Showing Dates
@Ian Macdonald Thanks Ian that worked a charm!
- Luke_Dyer
- 2 mths ago
- Questions & Answers
- Reported - view
PYTD vs YTD Comparison , while Not Showing Dates

I have a request which i cannot seem to get working correctly without showing dates. I want to compare suppliers YTD spend vs PYTD spend, so only dates up to today for this year and last.…
- Luke_Dyer
- 2 mths ago
- 2replies
- 31
- Questions & Answers
- Answered
- Answered
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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- 12replies
- 143
- Questions & Answers
- Answered
- Answered
Re: How to add subtotals for % Values to sum up to 100% in the category
Very useful function!
- Luke_Dyer
- 2 yrs ago
- Discover
- Reported - view

Back to top

Home

View all topics