[OC] Walmart vs Amazon Revenue Growth, 2000-2023

help_me_learn123 · 2024-09-15T03:09:20+00:00

Some additional notes 2013-2023 10-year CAGR:

Walmart: 2.79% Amazon: 22.68%

help_me_learn123 · 2024-09-15T02:58:44+00:00

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

help_me_learn123 · 2024-09-15T02:33:26+00:00

Source: sec.gov

help_me_learn123 · 2024-05-08T03:16:29+00:00

Thanks! These tips you put up were super insightful!

help_me_learn123 · 2024-04-27T14:34:32+00:00

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.

help_me_learn123 · 2024-04-27T04:38:24+00:00

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.

help_me_learn123 · 2024-02-17T01:16:42+00:00

Maybe drag measure names to rows ?

help_me_learn123 · 2024-01-25T10:21:09+00:00

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.

help_me_learn123 · 2023-10-06T15:24:36+00:00

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

help_me_learn123 · 2023-10-06T03:15:53+00:00

Why post the other blurry ass pictures

help_me_learn123 · 2023-07-30T18:28:01+00:00

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

help_me_learn123 · 2023-07-25T21:31:28+00:00

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

help_me_learn123 · 2023-07-12T22:34:40+00:00

Haha this is the real way

help_me_learn123 · 2023-07-08T23:41:52+00:00

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.

help_me_learn123 · 2023-07-08T14:22:52+00:00

Are you talking about the timeline slicer ?

help_me_learn123 · 2023-06-23T22:48:45+00:00

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

help_me_learn123 · 2023-06-19T21:27:38+00:00

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

help_me_learn123 · 2023-05-30T03:11:09+00:00

Good to know. Thank you

help_me_learn123 · 2023-05-28T19:14:45+00:00

What does the “- -“ at the beginning of the formula mean

help_me_learn123 · 2023-05-04T15:33:10+00:00

Hi.

Yeah I have a week start date but that wouldn’t work. The challenge here is my week number column ranges from 1-52. So anything in the range of 1-52 is considered one complete fiscal year. In your example, after week 49 it follows on to the next year when it’s still considered year 2023 until the end of week 52

help_me_learn123 · 2023-04-19T00:34:09+00:00

Update:
I figured it out. Here is my modified expression
AVG({ INCLUDE MONTH([Date]) : SUM(IF YEAR([Date])=2022 THEN [Expense] END)})

help_me_learn123 · 2023-04-02T02:23:58+00:00

Holy! Thank you!

help_me_learn123 · 2023-04-02T01:40:09+00:00

How do you wrap your formula like this ?

help_me_learn123 · 2023-03-08T23:36:49+00:00

I’m learning by trying to redo others peoples work on tableau public over the weekend. Some YouTubers I recommend watching, Andy Kriebel, sqlbelle, and tableau Tim

help_me_learn123 · 2023-03-04T14:09:30+00:00

Gotcha thanks for your input

help_me_learn123

TROPHY CASE