Display totals for each department

[former_member595028]

Hi, I have 5 kpi/measures that I have to display for each department, I have to display them under each state, I created 5 text boxes and tried using this formula,

DS_1.getData("_0s8EwfclEeO2O7b_CfOJQA",{});

Is there a script that I can use or I should just use this getdata for each text box.

[sapna_jgurudutt]

Hi,

Can you provide the following details:

1. Are you using Lumira Designer or Design Studio with regard to this issue?

2. What is the exact version, SP level and Patch level you are using?

3. What is the Datasource you are using?

Thanks & Regards,

Sapna

[reiner_hille-doering]

Best you modify your initial view until you see all the data that you want - including the sub totals on "department" dimension.

Then you can easily use the "Select Data..." feature on getData() content assist to create correct data selection JSON.