All Questions
3
questions
0
votes
1
answer
78
views
Excel Database for Questionnaire Results
I need to make an ongoing database for a questionnaire with 12 questions. The tick box options are Certainly True, Somewhat True, Not True and Dont Know.Each of these has a value. So if you select ...
0
votes
1
answer
3k
views
Excel SUM or COUNT based on related fields from two Tables
I have two tables in Excel
The small table with 50 rows...tblGroups[#Headers]= Employee ID; Name; Group.
The second table with 3000+ rows...tblData[#Headers]= EventID; Date; Employee ID; Value
Now ...
0
votes
1
answer
1k
views
Mapping of child elements
I can't find one good way to solve this problem. I will try to sum the issue as best as I can:
I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...