@marcsliving, im not shure if i understand you right
i was thinking about your approach, but im not shure if its possible to use your approach to extract data from a straight table.
its not about trying to extract data from a database table, the goal is to read data results from functions or other data from a straight/pivot table. the data i want to read/use is "produced" in the table.
So you want to use the result of a formula from the pivot in other places correct?
Using set analysis would capture the result of the formula as it would in the table. You just need to specify the dimensions in the formula.
In my example it is all from one table using sum(balance) on the pivot/straight table breaks it down by dimension. I needed to use just the total of Sales in a formula somewhere else. Using set analysis let me specify that I only want the balance if the group is Sales. If you have more than one dimension you can specify it in the set analysis to drill down the results even more.
If I am still not understanding correctly could you give more examples of what you are trying to do?