-
SORT on Pivot Table not working anymore
Hello, since a few days I have Pivot Table cards that dosen't let me sort them using the little 2 arrows in the column header ? Was working fine and then stop working. When I convert the card to mega table, it work. I'm I the only one with this trouble ?
-
Fixed filter allow : multiple allow
Hello, maybe it’s me, but I don’t seem able to specify multiple dimension in the filter allow or filter deny using the fixed function ? When I try it, only the first column is used, not the other. ex : sum(sum(count) fixed (by ‘name’ filter allow ´date’, ´region’)) ’date’ will work but not ´region’
-
% of contribution
Hi, I try to build a card where I can view the individual contribution over the total from the sales leader, for the month and where we view each month of the year. So I have a pivot table. Date view is This Year. Row : Sales Leader, Reps Column : Month Value : Sales, Contribution. Right now, I use this rule in my beast…
-
Total row sum % instead of doing the % calculation
Hi, I use one beastmode to give me the MTD % of achievement vs the MTD Target. On one card it work with this rule : sum(`product_A`)/(SUM(DISTINCT `product_a_Target_dly`)*DAY(CURDATE())) So it's giving me the MTD % even in the total row. I use the same formula on another card but with product_B.... and the total row show…
-
% of Contribution
Hi, I try to show the % of contribution and need some help with the beast mode. Right now, I have a Pivot table. Store are grouped by Sales Leader and the timeline is "This Year, By Month". I want to show the % of contribution of the store, in the Sale leader group and see evolution over month. I have try this beast mode :…
