Classic form layout option is not working

Answered
Manoranjan Gahana asked on June 6, 2018

Hi,
If web pivot doesn't have any measure and it contains two rows and one filter then when i am setting layout as a "classic form" then its not showing second row name  in web pivot,but its working if i am setting layout as "compact " or "tabular".
Please find the below code,
function onOpenLocal() {
pivot.updateData({
dataSourceType: "csv",
browseForFile: true
});
}
function onLoadRemote() {
var filename = prompt("Open remote CSV", "https://cdn.flexmonster.com/data/data.csv");
if (filename != null) {
pivot.updateData({
dataSourceType: "csv",
filename: filename
});
}
}
var pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
dataSourceType: "csv",
filename: "https://cdn.flexmonster.com/data/data.csv"
},
slice: {
"rows": [{
"uniqueName": "Country",
"sort": "unsorted"
}, {
"uniqueName": "Category",
"sort": "unsorted"
}],
"pages": [
{
"uniqueName": "Business Type"
}
],
"columns": [],
"measures": [],
expands: { expandAll: true }
},
options: {
configuratorActive: false,
grid:{
type:"classic"
}
}
},
width: "100%",
height: 400
});
 
Regards,
Manoranjan

3 answers

Public
Ian Sadovy Ian Sadovy Flexmonster June 7, 2018

Hello Manoranjan,
 
Thank you for reporting.
Actually, in "classic" mode you will see second row name only after expanding to this row. Since there are no measures, there is nothing to expand.
In any case, we treat slice without measures as "not valid", and users not able to create such slices via UI.
Please let me know if you have further questions.
 
Regards,
Ian

Public
Manoranjan Gahana June 8, 2018

Hi Ian ,
 
Thanks for the quick reply.
Actually in our case we are supporting both excel pivot and flex monster web pivot.
This scenario is supported in "excel pivot", thats why we are getting confusion.
 
Regards,
Manoranjan

Public
Tanya Gryshko Tanya Gryshko Flexmonster June 8, 2018

Hello, Manoranjan,
Thanks for the quick feedback!
We hope after the explanations from our side, the way Flexmonster works in such case is clear and does not cause further confusion.
Please do not hesitate to let us know if you have any questions.
Regards,
Tanya

Please login or Register to Submit Answer