robinhodemorais Posted November 19, 2019 Share Posted November 19, 2019 Hello, I am setting up an analysis with PivotGrid, but I have extremely important data that I need to show in detail according to each grouping. For example .... following the pivotgrid2 demo I want to create a% column where the none, nuse and tse grouping calculates the percentage over the total value and when I open the none grouping that details the values by rank I need to calculate the percentage of each rank over the total of none the first image is based on pivotgrid2, the second image is exactly my need, i will have other columns than the similar calculations .... how do I do ? Another important point, I can't narrow down the font. Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted November 25, 2019 Author Share Posted November 25, 2019 Hello, I need a feedback from moderators or admin if there is a solution for my need as I need to look for a solution! Quote Link to comment Share on other sites More sharing options...
Sherzod Posted November 25, 2019 Share Posted November 25, 2019 13 minutes ago, robinhodemorais said: Hello, I need a feedback from moderators or admin if there is a solution for my need as I need to look for a solution! Hello, Sorry for the late response. Percentage of what? Can you please explain once again? Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted November 25, 2019 Author Share Posted November 25, 2019 Ok, I will try to exemplify with a spreadsheet What I need is somehow dynamically calculating the% of each information according to its total and the total according to the other grouping, for example; The percentage of each purchasing group is calculated on the sum total of the purchasing groups, the percentage of the total purchasing group is calculated on the section total and the percentage of the section is calculated on the department total and the total of the department is calculated on the grand total, so I need it to be dynamic ... demo.xls Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted November 27, 2019 Author Share Posted November 27, 2019 is there any solution? Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted December 3, 2019 Author Share Posted December 3, 2019 need help Quote Link to comment Share on other sites More sharing options...
Freeman35 Posted December 4, 2019 Share Posted December 4, 2019 Maybe you can do this oncalculatedField, and column just show formated value Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted December 4, 2019 Author Share Posted December 4, 2019 but pivotgrid doesn't have this field and would need it because it brings these perfect groupings and totalizers ... Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted February 7, 2020 Author Share Posted February 7, 2020 Someone managed to mount something similar on PivoGrid, because I have some demands here and this guy would fit like a glove. Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted February 8, 2020 Author Share Posted February 8, 2020 Good night, I know you are very busy, but I need help, because I have a demand that I am not able to meet with the unigui, which for me is very bad since I am not able to do it and the client is requesting this result urgently . I really need somehow to be able to show a more dynamic result, to be able to manipulate a pivotgrid from devexpress, I don't care about dragging a column, my need is to show the results, to have a percentage column, however when opening a certain level the calculation of these results has to be different, I tried to use treegrid with several selects with union creating a totalizer, but the fact that the information doesn’t stay right in the detail line, being necessary to open the level is not usually good because it has a lot of information. I would like help with this solution, please! Quote Link to comment Share on other sites More sharing options...
Wicket Posted November 10, 2020 Share Posted November 10, 2020 Hi @robinhodemorais - Did you find a solution to this? Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted November 11, 2020 Author Share Posted November 11, 2020 11 hours ago, Wicket said: Hi @robinhodemorais - Did you find a solution to this? Unfortunately I couldn't find a solution 😔 Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted November 11, 2020 Share Posted November 11, 2020 vou responder em br, pq vc e meu vizinho. o pivot grid ate poderia fazer isso, mas esbarra ainda na limitação que nao vai deixar seu usuário mexer nas colunas, pensando nisso, entao porque usar o pivotgrid. pq vc so não gera um relatório para seu cliente com os agrupamentos e valores calculados. fazer isso no relatório e bem tranquilo, agora fazer a grade pivô fazer esses cálculos e mais complexo. pode ate existir um meio, mas vai ter que mexer em muito codigo js. o que importa e o resultado e nao a ferramenta usada .. eu faria isso como um relatorio no report builder ou qualquer outra ferramenta de relatórios que vc use. Quote Link to comment Share on other sites More sharing options...
robinhodemorais Posted November 11, 2020 Author Share Posted November 11, 2020 Oops, I will answer in English not to change this topic to the br rs, of course there will be several needs, but so far, all the reports I need to do with this type of calculation, I will not have the need to make it dynamic, not least because if there is a way to do this in the pivotgrid, it would be easy to create a way for the user to choose a form and then assemble it, an example is to use the pivot in a report where the user selects which columns he wants to see. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.