Forum

Trond Liavik
@trondlk
Trusted Member
Joined: Jun 22, 2019
Topics: 5 / Replies: 38
Topic
Forum
Replies: 20
Views: 484
Reply
RE: Sum with lookup when matching system codes (Salary codes)

Attachment uploaded again (please say if not available this time too). Trond

6 years ago
Reply
RE: Making "the golden graph"

Hi again, Sorry to say, but another problem came up when implementing the working solution today with my 100 thousands of rows with real data. T...

6 years ago
Reply
RE: Making "the golden graph"

Solution found; Formulas used: 1. TotalAmount2:=IF(ISBLANK(SUM ( Tabell1[Amount] ));"";SUM ( Tabell1[Amount] )) 2. TotalBudget2:=IF(ISBLANK(S...

6 years ago
Reply
RE: Making "the golden graph"

Hi Catalin, I'm not trying to twist Excel out of its logic - let me therefore correct my writing, that running totals for Amount for 201906-12 shou...

6 years ago
Reply
RE: Making "the golden graph"

Catalin, It seems like attachment disappears when editing posts here? Anyway, Excel v4 attached here =) Trond

6 years ago
Reply
RE: Making "the golden graph"

Hi Catalin, Thanks for your reply, the code looks interesting. However it doesn't work as planned. See attachment (v4). ALL vs ALLSELECTED: I tr...

6 years ago
Reply
RE: Making "the golden graph"

Philip Treacy said Hi Trond, There's no attachment. Regards Phil

6 years ago
Reply
RE: Making "the golden graph"

Hi Mynda, I'm happy for any help and suggestion with 'the golden graph'. It seems like some people have been reading this thread with interest as w...

6 years ago
Reply
RE: Making "the golden graph"

Hi Catalin! Unfortunately I'm not into measures formulas. If you see the attachment I just uploaded, how to insert/use measurement in this example?...

6 years ago
Reply
RE: Making "the golden graph"

Hi Anders (neighboor:) See attached file. From 201906 (June) to 201912 (December) there should be no values in the pivot table showing running tota...

6 years ago
Topic
Replies: 17
Views: 140
Page 3 / 3