Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let me fine tune my question.
Say, I have two table box(T1 & T2) and some other objects in my sheet. Is it possible to avoid reflection of the selection made in one table box to another table box but I dont care for other objects?
Point:
T1 and T2 should be independent i.e. my selection of row in T1 should not reflected in T2.
Can anyone help me please?
If you ún-check the 'Suppress Zero Values'in Presentation Tab, You could use the Straight table chart with only dimensions and no expressions. No need of writing macros. Quite a useful feature.
Instead of using a table box you could use a straight table type of chart and then check 'detached'.
Regards,
Gordon
Thanks for your reply Gordon.
But actually I'm not going to use any measures or facts in my table. Because of that if I tried to load my data into straight table it is not getting loaded.
Example :
A B C are the values, I'm going to load in the table not A,B,C,sum(D).
So it is not getting loaded in straight table case.
You can always create a dummy expression (such as a definition of 1) and then run the following code to make the width of the expression column 0 which will hide it (you only need to run it once):
sub AdjustCH
set chart = ActiveDocument.GetSheetObject("CH99") ' CHANGE THE OBJECT ID
set p = chart.GetProperties
set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual ' group.expression numbered from 0
expr.ColWidth = 0
chart.SetProperties p
end sub
Regards,
Gordon
If you ún-check the 'Suppress Zero Values'in Presentation Tab, You could use the Straight table chart with only dimensions and no expressions. No need of writing macros. Quite a useful feature.
Though, for your original problem, using Set Analysis might be a better option
hello,
Yes you can do it.
I use thefollowing in script to provide a separate tabnle ie a summary table static , ( not using detached) for when user views document they can view their data plus a regional view.
table123:
join (table123)
load
variable1 as staticvariable1,
variable2 as staticvariable2
resident mymaintable;
Thanks for your timely help
Hi cjwhit,
Really it is a very useful tip.
But I have a doubt on it. That is whether it take more memory?
From your example:
variable1 and variable2 are already available in the document, if I'm again loading it's value using staticvariable1 and staticvariable2 whether the values will loaded again? If no then how it works?
Hi All,
Thanks for your overwhelming response