Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! How to Calculate YTD by Month in a pivot table

I have a pivot table that works for my team. It looks like this: The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget). I have received a request to expand this pivot (or create a new one based o...

oliviar_0-1654019798132.png
oliviar by 7 - Data Storage
  • 6750 Views
  • 2 replies
  • 0 kudos

Resolved! How do I sum if or count if using conditional values?

Hi Community, I'm trying to figure out why my pivot table is returning incorrect values, and how to fix it.I need a variety of formulas that apply to each program in my pivot table to collect data about how much money we are contracted to receive, ho...

oliviar_7-1652199331670.png oliviar_8-1652199384350.png oliviar_1-1652198307796.png oliviar_2-1652198431447.png
oliviar by 7 - Data Storage
  • 3118 Views
  • 3 replies
  • 0 kudos

Resolved! Year-To-Date for Only Completed Months

Hello, I have a pivot table where I am calculating YTD vs. LYTD metrics by month, like this: I want to exclude April from this table as it is not a completed month and thus doesn't provide useful information. I can't figure out how to do that from th...

lharrison_0-1649101570166.png
lharrison by 8 - Cloud Apps
  • 1688 Views
  • 3 replies
  • 0 kudos

Using answer to a calculation within another calculation

Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total numbe...

CLewis_0-1643412425107.png CLewis_1-1643413787436.png
CLewis by 8 - Cloud Apps
  • 4103 Views
  • 4 replies
  • 0 kudos

Resolved! Ceiling Calculation

Wondering if any knows a way to use the ceiling calculation to round to the nearest 1000? I am trying to recreate this Excel calculation. =CEILING(P4,1000)-100 P4= $379,083.04 answer should be $379,900

CLewis by 8 - Cloud Apps
  • 1815 Views
  • 2 replies
  • 0 kudos

Resolved! Remove Widget Title Box

Hello. Is there any way to remove the title portion of a widget? I often don't place a title on indicator widgets, but the title box still limits how small the widget can be and leads to some awkward white-space. Is there any way to get rid of the bo...

lharrison_0-1635965694273.png lharrison_1-1635965830967.png
lharrison by 8 - Cloud Apps
  • 4695 Views
  • 1 replies
  • 1 kudos

Building a pivot table with TY vs LY with % growth

In a pivot table where I have the year 2021 data showing, how can I show the previous years sales (depending on which year has been selected from the main dashboard) including a % growth in the following columns in the pivot?

seakins by 7 - Data Storage
  • 3432 Views
  • 4 replies
  • 0 kudos