Kristoffer Drejer
BI developer at Triscan Smartparts. Responsible for constructing, and maintaing the datawarehouse storing our cubes, and developing and maitning our Targit solution. www.linkedin.com/in/kristoffer-drejer-69669b74
Comments
-
Hi Danilo You don't write how the data is presented, so assumed it was with month on the X axis, and shops on Y axis. Otherwise if you data is different, and this doesn't work, or you can't make ...
-
Hi Femke, Glad to hear that it worked :)
-
Super, looking forward to hear if it works.
-
Hi Femke, I just tried something else. It its not ideal, but it works at least :) Create a user dimension: Where Today(= selected date in dynamic date criteria) LastMonthToYesterday = Last month u...
-
Hi Femke As I understand you, it isn't an option to just exclude all dates where workday = 0 correct? Because then I would do the following, as it sounds similar to a case i've encountered. Let...
-
Have you tried making a new layout? Maybe, you could make an extra layout with the alternate end date. And then use that for the scheduled report?
-
Hi Jason, So it should only be row 3, and then the first column dimension? In That case you can make a second counting column: allcount(d1:0, 0, m2) And then for the rows this: In this case row ...
-
Hi Jason Try this then, create a new measure, just for counting so you just set it to 1 In my example the count measure is m2 Therefor for row 3 I do this: if sum(0, all, m2) + 1 = 3 then 100 e...
-
Hi Jason, Maybe something like: Just change the measure reference if wrong, but it seems from your picture that m3 is the ones you want to alter. if allcount(0,d1:0,m3) = 3 then "the formula for ...
-
Hi MatteoYou could create the criteria in your Data Warehouse:If you create a column in the table where the customer name dimensions are stored, you could do something like this perhaps? But probab...