Toad World® Forums

Pivot grid


#1

Hi,
3 issues: I’m playing with Pivot Grid:

  1. I change [in prefilter] operator to ‘is like’, but after applying and
    reopening

it switches back to ‘begins with’.

2.There is no info that Prefilter has been applied to shown data.

  1. Could you please, add possibility to switch off ‘Grand totals’?
    Unfortunately, chart shows data basing on selected cells [in grid]
    To analyze whole data easiest way is to select them all. But doing this I also
    takes
    ‘grand total’ row / col and it disturbs data presentation.


Butter

int_1.jpeg

int_2.jpeg

int_3.jpeg
int_1.jpeg


#2

Hi Marcin,

  1. this works fine on my current build. Unfortunately I’ve reinstalled 683
    Beta build with new beta cadidate, so I can’t see how it works in your
    build.

  2. agreed. Will make a CR for this.

  3. Deselect ‘Chart Selection Only’ option (see below). Also you can
    hide Totals rows/columns from the chart:

regards,

Alexander Maximov


#3

Hi Marcin,

  1. this works fine on my current build. Unfortunately I’ve reinstalled 683
    Beta build with new beta cadidate, so I can’t see how it works in your
    build.

  2. agreed. Will make a CR for this.

  3. Deselect ‘Chart Selection Only’ option (see below). Also you can
    hide Totals rows/columns from the chart:

regards,

Alexander Maximov
image004.jpeg


#4

Hi Marcin,

  1. this works fine on my current build. Unfortunately I’ve reinstalled 683
    Beta build with new beta cadidate, so I can’t see how it works in your
    build.

  2. agreed. Will make a CR for this.

  3. Deselect ‘Chart Selection Only’ option (see below). Also you can
    hide Totals rows/columns from the chart:

regards,

Alexander Maximov
image003.jpeg


#5

Hi Marcin,

  1. this works fine on my current build. Unfortunately I’ve reinstalled 683
    Beta build with new beta cadidate, so I can’t see how it works in your
    build.

  2. agreed. Will make a CR for this.

  3. Deselect ‘Chart Selection Only’ option (see below). Also you can
    hide Totals rows/columns from the chart:

regards,

Alexander Maximov
int_1.jpeg


#6
  1. Deselect ‘Chart Selection Only’ option (see below). Also you can hide
    Totals rows/columns from the chart:
    […] .,___

Alexander,
thanks for info. Maybe you should consider to copy [/ move ] this menu to other
places
e.g. toolbar. I thought this button / menu is related to chart, not to whole
Pivot Grid
and even not looked there.

Imho such movement could make Toad more user friendly

Butter


#7
  1. agreed. Will make a CR for this.

I found information about prefilter [it is on the bottom of window].
Because prefilter could be applied to many columns, I think that my request is
not as good
as I thought ;(

But maybe I can ‘change’ request :wink:
Could you make changes made to Chart options [your previous mail] more
permanent?
Now I have to change settings each time I use want to use pivot grid.

And 4 more issues:

  1. there is na option :setup grid / Grouping
    Now I can group only by first letter. It would be much better [at least for
    me;)]
    to allow user enter how many character [s]he would like to group by

2.What is ‘red’ button for? There is no hint, no reaction for pressing it.

  1. [improvement proposal]
    ‘Display Conditions’ - could you show here a chosen summary method?
    [ count of (ko_nazwa) instead of ko_nazwa]
    First time I have to spend a moment considering why I’m allowed to format data
    that is
    next summarized [count/ min / max/ avg]:wink:

  2. Formatting is nice, but without possibility to use its result in other
    application
    it is almost useless ;((


Butter
int_2.jpeg


#8
  1. agreed. Will make a CR for this.

I found information about prefilter [it is on the bottom of window].
Because prefilter could be applied to many columns, I think that my request is
not as good
as I thought ;(

But maybe I can ‘change’ request :wink:
Could you make changes made to Chart options [your previous mail] more
permanent?
Now I have to change settings each time I use want to use pivot grid.

And 4 more issues:

  1. there is na option :setup grid / Grouping
    Now I can group only by first letter. It would be much better [at least for
    me;)]
    to allow user enter how many character [s]he would like to group by

2.What is ‘red’ button for? There is no hint, no reaction for pressing it.

  1. [improvement proposal]
    ‘Display Conditions’ - could you show here a chosen summary method?
    [ count of (ko_nazwa) instead of ko_nazwa]
    First time I have to spend a moment considering why I’m allowed to format data
    that is
    next summarized [count/ min / max/ avg]:wink:

  2. Formatting is nice, but without possibility to use its result in other
    application
    it is almost useless ;((


Butter
int_1.jpeg


#9

From what I see it is related to Chart only. It doesn’t hide Grand Total
for rows/columns for Pivot.

Will try to investigate this with the team.

regards,

Alexander Maximov