jahlxx Posted November 26, 2020 Share Posted November 26, 2020 Hi. First of all, sorry for this, is possible that this is answered in some previous topic. I'm new with pivotgrid and can't gert what I am looking for, an the sample doesn't helps me. I have this query: select banco, producto, referencia, sum(importe1) pb_saldo, sum(importe2) pb_prestamo, sum(importe3) pb_limldesc, sum(importe4) pb_displdesc, sum(importe5) pb_limlcred, sum(importe6) pb_displcred from ( select a.des_banco as banco, des_pf as producto, referencia, (case when a.cod_pf = 0 then a.importe else 0 end) as importe1, (case when a.cod_pf = 2 then a.importe else 0 end) as importe2, (case when a.cod_pf = 1 then a.limite else 0 end) as importe3, (case when a.cod_pf = 1 then a.importe else 0 end) as importe4, (case when a.cod_pf = 7 then a.limite else 0 end) as importe5, (case when a.cod_pf = 7 then a.importe else 0 end) as importe6 from tabla a where a.comp = :c1 ) x group by banco, producto, referencia order by 1 And need to build a pivotgrid. I fill the leftaxis property, with banco, producto and referencia, and is shown ok. My problem is that I don't know how to show the other fields as columns. I've tried with topaxis, aggregators, and drilldows columns, with no success. I've tried some combinations, but can't get it. Maybe this is a stupid mistake, or something I'm doing wrong, sure due to my ignorance. Some help please. Thanks. Quote Link to comment Share on other sites More sharing options...
jahlxx Posted November 26, 2020 Author Share Posted November 26, 2020 Hi. As I can see, a column for topaxis is needed, isn't it? Thanks. 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.