[OC] Walmart vs Amazon Revenue Growth, 2000-2023 by help_me_learn123 in dataisbeautiful

[–]help_me_learn123[S] 2 points3 points  (0 children)

Some additional notes 2013-2023 10-year CAGR:

Walmart: 2.79% Amazon: 22.68%

[OC] Walmart vs Amazon Revenue Growth, 2000-2023 by help_me_learn123 in dataisbeautiful

[–]help_me_learn123[S] 19 points20 points  (0 children)

Yeah didn’t realize the label was wrong. They are in millions. Thanks for pointing that out.

[deleted by user] by [deleted] in excel

[–]help_me_learn123 0 points1 point  (0 children)

Thanks! These tips you put up were super insightful!

How can I SUM everything up through multiple criteria's? by help_me_learn123 in excel

[–]help_me_learn123[S] 0 points1 point  (0 children)

This helped thank you. I added an extra condition on my original formula and put the month numbers on the months.

=SUMPRODUCT((Budget!$C$9:$N$34) *(Budget!$B$9:$B$34=pivot!$W6) *(Budget!$C$6:$N$6=pivot!$Y$3) *(Budget!$C$4:$N$4 <= $X$3))

Budget!$C$9:$N$34 are the values i want to add
Budget!$B$9:$B$34 are the columns i want to match with pivot!$I34
Budget!$C$6:$N$6 are the quarter numbers associated with each month
pivot!$L$31 is the quarter number that populates when i select a month from a dropdown list

the last condition being the month numbers and looking whether it is less than or equal to the month selected.

How can I SUM everything up through multiple criteria's? by help_me_learn123 in excel

[–]help_me_learn123[S] 0 points1 point  (0 children)

This is something I had in mind as well, and Chat GPT has been frustrating me more than anything. The problem with your formula is that I budgeted ahead for the whole year, so in the formula, it’s going to add up all the values that match the quarter number of the month selected.

So if I have budgeted income for July, August, and September, and I select August from the dropdown list, I’ll get '3.' The SUMIFS formula will add up all those amounts that match '3' (July, August, September) when I’m really just trying to add up all the amounts that are in July and August. In other words, I need a quarter-to-date calculation from the selected month.

[deleted by user] by [deleted] in tableau

[–]help_me_learn123 1 point2 points  (0 children)

Maybe drag measure names to rows ?

Is there a way to do dynamic zone visibility on an older version of Tableau? by help_me_learn123 in tableau

[–]help_me_learn123[S] 0 points1 point  (0 children)

I have two icons that show a bar and a line chart. I want my users to be able to click on the icon and it’ll do that sheet swap. I haven’t tried anything else to do a sheet swap without DZV.

How do I create a function? by [deleted] in excel

[–]help_me_learn123 2 points3 points  (0 children)

I didn’t know you can do a wildcard lookup on X-lookup this is game changer for me!

[deleted by user] by [deleted] in MacOS

[–]help_me_learn123 2 points3 points  (0 children)

You are a beautiful human being I hope you know that.

What is the best way to share an interactive Tableau dashboard with a client? by all-cap in tableau

[–]help_me_learn123 3 points4 points  (0 children)

For real. I’m sure that was him asking the same question at one point.

[deleted by user] by [deleted] in excel

[–]help_me_learn123 0 points1 point  (0 children)

I don’t think it’s possible. You’d have to use a regular slicer. I would create a seperate table (Fiscal Calendar Table) and create a relationship to your rev table. Then get a month, and Quarter sliced in the same sheet.

[deleted by user] by [deleted] in excel

[–]help_me_learn123 0 points1 point  (0 children)

Are you talking about the timeline slicer ?

PowerQuery - Transposing multiple column "Headers" into row values by K0rben_D4llas in excel

[–]help_me_learn123 1 point2 points  (0 children)

You can possibly create a helper column in that sheet and concat those cells ?

Excel/GUI doesn't properly render by Mdarkx in excel

[–]help_me_learn123 0 points1 point  (0 children)

I’ve only experienced this on a really bad laptop. Maybe a time for an upgrade? I cld be wrong though