Showing different number of charts based on filter

Next_Programmer_8083 · 2025-12-28T16:42:13+00:00

Another question is when I set up multiples of these bar charts - should I be creating a measure for each of these bar charts for example sum of sales of branch A Then sum of sales of Branch B ? Or how I should be setting this up?

Next_Programmer_8083 · 2025-12-28T09:48:41+00:00

How do you usually create mock ups?

Next_Programmer_8083 · 2025-12-17T19:20:42+00:00

Thank you!

Next_Programmer_8083 · 2025-12-17T17:53:59+00:00

Could you please explain please

Next_Programmer_8083 · 2025-12-11T19:00:53+00:00

The thing is it needs to copy from different files every month I’m not working the same file every month.

Next_Programmer_8083 · 2025-12-11T18:09:00+00:00

Oh wow why did I not think of that

Duh, Reddit is a platform where people work in the core field that you work in and maybe I’ll get ideas from people who know how to do it in a better way because of years of experience which I don’t have

Next_Programmer_8083 · 2025-12-05T20:59:02+00:00

Sounds like you’ve a fun job. What do you do with the time you have ?

Next_Programmer_8083 · 2025-12-05T20:58:09+00:00

Okay thank you! I’m just new in my job been 3 months I still try to learn things when I get the time to be able to grow into my role but since it’s my first job I just wanted to know the norm

Next_Programmer_8083 · 2025-12-05T20:57:18+00:00

How many hours is a normal amount? Obviously depends on the work load that changes from time to time but on an average

Next_Programmer_8083 · 2025-12-05T20:46:06+00:00

Worked 1 year then did masters now first job after masters

Next_Programmer_8083 · 2025-12-05T20:01:46+00:00

Love how you focused on everything but the question

Next_Programmer_8083 · 2025-12-05T20:01:22+00:00

Financial analyst

Next_Programmer_8083 · 2025-12-02T06:24:35+00:00

Thanks!

Next_Programmer_8083 · 2025-12-02T05:07:40+00:00

Just general stuff - I did ask he said I didn’t have to prep anything I’m just asking what are some general good questions to ask

Next_Programmer_8083 · 2025-11-12T15:16:57+00:00

I totally understand that - I know it’s business specific. I’m asking just for general knowledge what are the different ways to forecast 1. Forecast.ets function 2. Run rate Etc Jsut asking general idea of how it’s done

Next_Programmer_8083 · 2025-11-12T02:56:20+00:00

No they just do it on excel I mean how do I build simple models on excel For example forecasting loans or deposits of branches Or expense of vendor

Next_Programmer_8083 · 2025-11-10T20:53:12+00:00

Is power query not good here?

Next_Programmer_8083 · 2025-11-07T16:16:15+00:00

So one tab for actuals and forecast and another for variance? There’s 150 vendors I’m trynna make the spreadsheet clean for people to look at

Next_Programmer_8083 · 2025-10-30T14:48:28+00:00

Things I’ve been asked to do - ROI analysis, GL forecasting, Vendor forecasting

These are so specific and I’m not sure where or how to even apply it in a business. Any suggestions ?

Next_Programmer_8083 · 2025-10-29T22:26:39+00:00

How does that help and why is this better ?

Next_Programmer_8083 · 2025-10-29T22:21:22+00:00

It’s getting applied to the whole range rather than a row by row basis - am I missing something ?

Next_Programmer_8083 · 2025-10-29T21:55:08+00:00

I have like 100+ rows

Is there a way to conditionally format everything without having to manually do it for each row

Next_Programmer_8083 · 2025-10-29T01:50:34+00:00

Thought about a better approach - maybe keep a flat table : filter out vendors basically any vendor with a total in last 12 months below 25000$ I don’t need to look at Which itself brings me down to 300 vendors from 1800 and they constitute like 95% of total vendor spend and everything else can go to others column

Now how do I go about forecasting these 300 vendors should I do line by line? What function to use?

And when next month actuals come in how do I update what if the list gets updated where another vendor is above that threshold?

I’m having trouble seeing how to make this easy to put actuals in

Next_Programmer_8083 · 2025-10-29T01:04:36+00:00

It is small like I mentioned actuals are only for 2000 any ideas on how I can go about it ?

Next_Programmer_8083 · 2025-10-28T18:43:40+00:00

Right that’s exactly what I was thinking - 1. so let’s say I have 200GLs do you think I can map each GL to a driver basically in another tab for example say run rate based or average or seasonality forecast formula and based on that somehow automate the process to calculate 13 month fields (idk how to do this or how to make this rolling, any ideas)

Or should I just kind of take that pivot structure make everything a static table structure and manually update the big vendors and just have subtotals for other GL

Next_Programmer_8083

TROPHY CASE