ErickRuiz7
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Percentaje Over Column Grand Total
Hello team, I have the following Pivot Table built on Sisense, The FLM rows are the names of our managers, the columns 1p, 2p, 3p, 4p are the combo packages sold to our clients, Im getting the grand total each FLM has, but I would like to check if there is anyway to get the % over the grand total. Example: The first row FLM sold a total of 109 products, but out of those 109 products, 26 are 1p. I would like to perform a division 26/109 = 23.85% out of all sales made by that FLM are 1p packages. This is what Im looking for, Im looking to divede each FLM sales per packege over their own grand total. Regards,406Views0likes4CommentsRe: SUM based on Text Criteria
Thanks for the suggestion, I tried it and partially work, but I forgot to mention that the question can repeat several times, I have a total of 6 different questions and a total of 950 answers to each question, the approach is conting only 6, do you have any suggestion for me?2.3KViews0likes1CommentSUM based on Text Criteria
I have a STRING column called Question, this question column provides two possible answeres, either 'Yes; or 'No' How do I create formulas to sum the amount of times a Yes shows up, the amount of times a No shows up and the amount of times that both of them show up?Solved2.4KViews0likes5CommentsHorizontal Contribution
Hi Sisense Devs, I'm using a Pivot Table Visual in which Im using employee_name as my rows, phone state as columns (With over 15 categories), phone state duration as values, I converted the values to % using the CONTRIBUTION formula on Sisense, but Im getting the contribution per Column, this is something I don't need at this time, what I actually need is the contribution per row, is there anything I can do using only formulas or would I need a custom code table on the cube? Thank you all.Solved1.5KViews0likes2Comments