Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table box (not a pivot, or a straight table chart) in which all the data displayed is informational, or dimensional, in nature. However, some of that information is more important that others and I have been asked if there is a way to lock a couple of the columns while allowing the others to scroll - aka Excel. There are currently 25 columns (most descriptive text) with them wanting to add a few more. However, they want to be able to keep track of the two or three key columns as they scroll through the rest.
Can this be done?
Thank you.
How about using a straight table and declaring the fixed columns as dimensions, the remaining ones as expressions using =Only(Field)
How about using a straight table and declaring the fixed columns as dimensions, the remaining ones as expressions using =Only(Field)
Being relatively new to QV, I was not aware of the Only() function. I'll give it a try and let you know.
...Later...
That does it! Thank you