Comments
-
If i were to use % column total is not right for my scenario. as stated, my measures include sales, cost, income, for my calculation, i need to use 14,312,756 as my denominator, which later equivalent to 100%. the suggestion will take sales + cost + income=100% .
-
to further add on, 01-May, 02-Jun, 03-Jul is my way of arranging the month name in ascending format when i pick Financial Year in variable. if i switch to Gregorian Year in variable, it will show 01-Jan, 02-Feb, 03-Mar(month name) accordingly. i do have 2 different fields for Gregorian Date and Financial Date, i.e.…
-
Regarding on adding 1 extra field - Previous Month Sales in the ETL process, I stumbled upon this tutorial ytdy , is it this one? I am thinking this will be my last resort if I have no solution https://www.youtube.com/watch?v=oH0nUfVEsWA Hoping i can fix it just using calculated field, because I can do a similar…
-
I have 2 variables, the first is Calendar type (Gregorian/Financial), and my second variable is Year (2025/2024/2023). The dataset is monthly data, so no date involved here, but I did prepared 2 extra fields (Gregorian Date & Financial Date), but they are just placeholder, meaning 2024-01-01, 2025-04-01 no exact date,…
-
-
