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
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
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
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